Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 3F6F5475F83 for ; Wed, 1 May 2002 13:03:21 -0400 (EDT) Received: from charon.npc.net (charon.npc.net [199.15.61.3]) by postgresql.org (Postfix) with ESMTP id 2641E47610B for ; Wed, 1 May 2002 12:51:27 -0400 (EDT) Received: from mail.npc.net ([172.20.0.18]) by charon.npc.net (8.11.3/8.11.3) with ESMTP id g41GfUY58171 for ; Wed, 1 May 2002 12:41:31 -0400 (EDT) Received: from hoyltr1 ([172.20.0.114]) by mail.npc.net (Netscape Messaging Server 4.15 mail Dec 7 2001 09:58:59) with SMTP id GVFYTW00.T6R for ; Wed, 1 May 2002 12:51:32 -0400 From: "Travis Hoyt" To: Subject: Problems returning multiple columns Date: Wed, 1 May 2002 12:51:29 -0400 MIME-Version: 1.0 Message-ID: X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) Content-Type: multipart/signed; micalg=SHA1; protocol="application/x-pkcs7-signature"; boundary="----=_NextPart_000_018D_01C1F10E.E8D5DAD0" Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Archive-Number: 200205/3 X-Sequence-Number: 7639 This is a multi-part message in MIME format. ------=_NextPart_000_018D_01C1F10E.E8D5DAD0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit CREATE FUNCTION wklyavg(numeric, timestamp, timestamp) RETURNS TEXT AS ' DECLARE system ALIAS FOR $1; startdate ALIAS FOR $2; enddate ALIAS FOR $3; result numeric; BEGIN result := (select (avg(usr) + avg(sys)) from sardata where systemid = system and time between startdate and enddate); return enddate || result; END; ' LANGUAGE 'plpgsql'; Above is the function I'm trying to run and I keep getting errors telling me I need to cast my values. I've played with it a bit but not knowing much about casting I was hoping for some help. I'm basically just summing a couple of averages for values between two given dates. I wanted to return the summed average and the "enddate" as one row. Any suggestions? Thanks, Travis ------=_NextPart_000_018D_01C1F10E.E8D5DAD0 Content-Type: application/x-pkcs7-signature; name="smime.p7s" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="smime.p7s" MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEH AQAAoIIJIDCCAr4wggInoAMCAQICAwZt8zANBgkqhkiG9w0BAQIFADCBkjEL MAkGA1UEBhMCWkExFTATBgNVBAgTDFdlc3Rlcm4gQ2FwZTESMBAGA1UEBxMJ Q2FwZSBUb3duMQ8wDQYDVQQKEwZUaGF3dGUxHTAbBgNVBAsTFENlcnRpZmlj YXRlIFNlcnZpY2VzMSgwJgYDVQQDEx9QZXJzb25hbCBGcmVlbWFpbCBSU0Eg MjAwMC44LjMwMB4XDTAyMDEwMzE2MjAwN1oXDTAzMDEwMzE2MjAwN1owdjEN MAsGA1UEBBMESG95dDEPMA0GA1UEKhMGVHJhdmlzMRQwEgYDVQQDEwtUcmF2 aXMgSG95dDEcMBoGCSqGSIb3DQEJARYNdGhveXRAbnBjLm5ldDEgMB4GCSqG SIb3DQEJARYRdC5ob3l0QGFsbHRlbC5uZXQwgZ8wDQYJKoZIhvcNAQEBBQAD gY0AMIGJAoGBANbRK60nLCiGPa34o7ADVuScL3D8gq+E51OuCHbHMihMG+FF Onps8sgoj+UPqOBlYCJoEfmk3PaYaZyxfJvpdRWcJAuMFKIYKuTk9WtJoitf NBegwSnt50agD9+R0lwBHQFUq4fzLL3TTBFLP98CIGCi7162Xh8b7YxrxotQ Ins3AgMBAAGjPTA7MCsGA1UdEQQkMCKBDXRob3l0QG5wYy5uZXSBEXQuaG95 dEBhbGx0ZWwubmV0MAwGA1UdEwEB/wQCMAAwDQYJKoZIhvcNAQECBQADgYEA OgHIL+z1uJS29KQGHtr1Dy9Deal7Co4KsW8v8nvi1F8kmQFaAUZRj9I7IsTY qc9oqjbEVREq/e760H+Yu0UxHhMgCfSpnSlUjd/uUb+IGFAmrTHQ84G/9nnn lm3+9q5d1TRcQC985RdTlV+0dE+dtQS+hCsrwaE7+dpNmL2CbK4wggMpMIIC kqADAgECAgEMMA0GCSqGSIb3DQEBBAUAMIHRMQswCQYDVQQGEwJaQTEVMBMG A1UECBMMV2VzdGVybiBDYXBlMRIwEAYDVQQHEwlDYXBlIFRvd24xGjAYBgNV BAoTEVRoYXd0ZSBDb25zdWx0aW5nMSgwJgYDVQQLEx9DZXJ0aWZpY2F0aW9u IFNlcnZpY2VzIERpdmlzaW9uMSQwIgYDVQQDExtUaGF3dGUgUGVyc29uYWwg RnJlZW1haWwgQ0ExKzApBgkqhkiG9w0BCQEWHHBlcnNvbmFsLWZyZWVtYWls QHRoYXd0ZS5jb20wHhcNMDAwODMwMDAwMDAwWhcNMDIwODI5MjM1OTU5WjCB kjELMAkGA1UEBhMCWkExFTATBgNVBAgTDFdlc3Rlcm4gQ2FwZTESMBAGA1UE BxMJQ2FwZSBUb3duMQ8wDQYDVQQKEwZUaGF3dGUxHTAbBgNVBAsTFENlcnRp ZmljYXRlIFNlcnZpY2VzMSgwJgYDVQQDEx9QZXJzb25hbCBGcmVlbWFpbCBS U0EgMjAwMC44LjMwMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDeMzKm Y8cJJUU+0m54J2eBxdqIGYKXDuNEKYpjNSptcDz63K737nRvMLwzkH/5NHGg o22Y8cNPomXbDfpL8dbdYaX5hc1VmjUanZJ1qCeu2HL5ugL217CR3hzpq+AY A6h8Q0JQUYeDPPA5tJtUihOH/7ObnUlmAC0JieyUa+mhaQIDAQABo04wTDAp BgNVHREEIjAgpB4wHDEaMBgGA1UEAxMRUHJpdmF0ZUxhYmVsMS0yOTcwEgYD VR0TAQH/BAgwBgEB/wIBADALBgNVHQ8EBAMCAQYwDQYJKoZIhvcNAQEEBQAD gYEAcxtvJmWL/xU0S1liiu1EvknH6A27j7kNaiYqYoQfuIdjdBxtt88aU5FL 4c3mONntUPQ6bDSSrOaSnG7BIwHCCafvS65y3QZn9VBvLli4tgvBUFe17BzX 7xe21Yibt6KIGu05Wzl9NPy2lhglTWr0ncXDkS+plrgFPFL83eliA0gwggMt MIIClqADAgECAgEAMA0GCSqGSIb3DQEBBAUAMIHRMQswCQYDVQQGEwJaQTEV MBMGA1UECBMMV2VzdGVybiBDYXBlMRIwEAYDVQQHEwlDYXBlIFRvd24xGjAY BgNVBAoTEVRoYXd0ZSBDb25zdWx0aW5nMSgwJgYDVQQLEx9DZXJ0aWZpY2F0 aW9uIFNlcnZpY2VzIERpdmlzaW9uMSQwIgYDVQQDExtUaGF3dGUgUGVyc29u YWwgRnJlZW1haWwgQ0ExKzApBgkqhkiG9w0BCQEWHHBlcnNvbmFsLWZyZWVt YWlsQHRoYXd0ZS5jb20wHhcNOTYwMTAxMDAwMDAwWhcNMjAxMjMxMjM1OTU5 WjCB0TELMAkGA1UEBhMCWkExFTATBgNVBAgTDFdlc3Rlcm4gQ2FwZTESMBAG A1UEBxMJQ2FwZSBUb3duMRowGAYDVQQKExFUaGF3dGUgQ29uc3VsdGluZzEo MCYGA1UECxMfQ2VydGlmaWNhdGlvbiBTZXJ2aWNlcyBEaXZpc2lvbjEkMCIG A1UEAxMbVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIENBMSswKQYJKoZIhvcN AQkBFhxwZXJzb25hbC1mcmVlbWFpbEB0aGF3dGUuY29tMIGfMA0GCSqGSIb3 DQEBAQUAA4GNADCBiQKBgQDUadfUsJRkW3HpR9gMUbbqcpGwhF59LQ2PexLf hSV1KHQ6QixjJ5+Ve0vvfhmHHYbqo925zpZkGsIUbkSsfOaP6E0PcR9AOKYA o4d49vmUhl6t6sBeduvZFKNdbnp8DKVLVX8GGSl/npom1Wq7OCQIapjHsdqj mJH9edvlWsQcuQIDAQABoxMwETAPBgNVHRMBAf8EBTADAQH/MA0GCSqGSIb3 DQEBBAUAA4GBAMfskn5O+PWWpWdiKqTwTRFg0G+NYFhhrCa7UjVcCM8w+6hK loofYkIjjBcP9LpknBesRynfnZhe0mxgcVyirNx54+duAEcftQ0o6AKd5Jr9 E/Sm2Xyx+NxfIyYJkYBz0BQb3kOpgyXy5pwvFcr+pquKB3WLDN1RhGvk+NHO d6KBMYICqjCCAqYCAQEwgZowgZIxCzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxX ZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEPMA0GA1UEChMGVGhh d3RlMR0wGwYDVQQLExRDZXJ0aWZpY2F0ZSBTZXJ2aWNlczEoMCYGA1UEAxMf UGVyc29uYWwgRnJlZW1haWwgUlNBIDIwMDAuOC4zMAIDBm3zMAkGBSsOAwIa BQCgggFlMBgGCSqGSIb3DQEJAzELBgkqhkiG9w0BBwEwHAYJKoZIhvcNAQkF MQ8XDTAyMDUwMTE2NTEyOFowIwYJKoZIhvcNAQkEMRYEFMO8qzQvr8bX0CEi JJU+aBjbmyaqMFgGCSqGSIb3DQEJDzFLMEkwCgYIKoZIhvcNAwcwDgYIKoZI hvcNAwICAgCAMAcGBSsOAwIHMA0GCCqGSIb3DQMCAgEoMAcGBSsOAwIaMAoG CCqGSIb3DQIFMIGrBgkrBgEEAYI3EAQxgZ0wgZowgZIxCzAJBgNVBAYTAlpB MRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEP MA0GA1UEChMGVGhhd3RlMR0wGwYDVQQLExRDZXJ0aWZpY2F0ZSBTZXJ2aWNl czEoMCYGA1UEAxMfUGVyc29uYWwgRnJlZW1haWwgUlNBIDIwMDAuOC4zMAID Bm3zMA0GCSqGSIb3DQEBAQUABIGAaq31NYgt5nglY5Pb10B4FOjR3lnuqF0+ BsI9puFq34HnlzxzneOSl8ExaGd7xaxunDCvmp8WVqkcSizmzh6jzQ0KEmEw 0qU/Wg5exTe+az/G4hwOQLjva6jpytOE34szI7/oIvU/kem3HjH6qBENyBpY A3nnSNHEvyXLPVFDKgYAAAAAAAA= ------=_NextPart_000_018D_01C1F10E.E8D5DAD0--