Re: Function compile error

#1

On Fri, 2004-07-16 at 22:04, Steve Tucknott wrote:

Quote:

Can anyone help with this? I'm new to Postgre and plpgsql - but have
some experience of sql/plsql and Informix procedures.
I have converted an Informix procedure to plpgsql - and get the
following error when the function is executed:
NOTICE: plpgsql: ERROR during compile of proc_allowed near line 3
ERROR: parse error at or near "AS"

The procedure is attached.

__________________________________________________ ____________________
CREATE FUNCTION proc_allowed
....
DECLARE
p_key ALIAS AS $1;

Should be: ALIAS FOR $1

--
Oliver Elphick olly (AT) lfix (DOT) co.uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
========================================
"For God so loved the world, that he gave his only
begotten Son, that whosoever believeth in him should
not perish, but have everlasting life." John 3:16

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Function compile error

comp.databases.postgresql.novice comp.databases.postgresql.novice

Re: Function compile error - 07-18-2004 , 05:13 PM