On Fri, 2004-07-16 at 22:04, Steve Tucknott wrote:
> 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
> p_key ALIAS AS $1;
Should be: ALIAS FOR $1
Oliver Elphick olly(at)lfix(dot)co(dot)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
In response to
pgsql-novice by date
|Next:||From: Scott Marlowe||Date: 2004-07-18 22:39:12|
|Subject: Re: Calling Functions and Stored Procedures|
|Previous:||From: Josh Berkus||Date: 2004-07-18 20:09:23|
|Subject: Re: SQL - Indexing for performance on uniquness check...|