Re: Function compile error

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
...
> DECLARE
> 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