Received: from charon.npc.net (mail.npc.net [199.15.61.3]) by postgresql.org (Postfix) with ESMTP id D9B79475C0A for ; Wed, 27 Mar 2002 15:00:00 -0500 (EST) Received: from mail.npc.net ([172.20.0.18]) by charon.npc.net (8.11.3/8.11.3) with ESMTP id g2RJp1n31632 for ; Wed, 27 Mar 2002 14:51:02 -0500 (EST) Received: from hoyltr1 ([172.20.0.114]) by mail.npc.net (Netscape Messaging Server 4.15) with SMTP id GTNE8000.GDO for ; Wed, 27 Mar 2002 15:00:00 -0500 From: "Travis Hoyt" To: Subject: function error Date: Wed, 27 Mar 2002 14:59:39 -0500 Message-ID: MIME-Version: 1.0 X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) Importance: Normal Content-Type: multipart/signed; micalg=SHA1; protocol="application/x-pkcs7-signature"; boundary="----=_NextPart_000_0719_01C1D5A0.0151DB70" X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Archive-Number: 200203/362 X-Sequence-Number: 7236 This is a multi-part message in MIME format. ------=_NextPart_000_0719_01C1D5A0.0151DB70 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit CREATE FUNCTION biwklyavg(text, text, text) RETURNS numeric AS ' DECLARE system ALIAS $1; startdate ALIAS $2; enddate ALIAS $3; result numeric; BEGIN result := (select (avg(usr) + avg(sys)) from sardata where systemid = system and time between startdate and enddate; END; ' LANGUAGE 'sql'; Hello, The fuction listed above gives the following error: ERROR: parser: parse error at or near "alias" I'm running v7.2. Any ideas? I pulled this directly from the examples in the PostgreSQL Developer's Handbook. Thanks, Travis ------=_NextPart_000_0719_01C1D5A0.0151DB70 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 MQ8XDTAyMDMyNzE5NTkzM1owIwYJKoZIhvcNAQkEMRYEFO9gP0K/uefQrAli mK/qhuiu/itnMFgGCSqGSIb3DQEJDzFLMEkwCgYIKoZIhvcNAwcwDgYIKoZI hvcNAwICAgCAMAcGBSsOAwIHMA0GCCqGSIb3DQMCAgEoMAcGBSsOAwIaMAoG CCqGSIb3DQIFMIGrBgkrBgEEAYI3EAQxgZ0wgZowgZIxCzAJBgNVBAYTAlpB MRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEP MA0GA1UEChMGVGhhd3RlMR0wGwYDVQQLExRDZXJ0aWZpY2F0ZSBTZXJ2aWNl czEoMCYGA1UEAxMfUGVyc29uYWwgRnJlZW1haWwgUlNBIDIwMDAuOC4zMAID Bm3zMA0GCSqGSIb3DQEBAQUABIGAhbEEA+7ar/qyhjGZGJa9gI0wFy+Y1Of6 1FK4SZSkkMkozPEwcaXN+JIUw5ERM8csUqBGTkuEyTw1au4Yg7mPmAfxRTxC 6EblD4l8eVTQxrxWLWo65l0FuQfqSk3ccmodbaHsy+bXBB/zn1avAfHzrinL xQbemW8MwGdGk2M/7wsAAAAAAAA= ------=_NextPart_000_0719_01C1D5A0.0151DB70--