Re: Function compile error - Mailing list pgsql-novice

From Oliver Elphick
Subject Re: Function compile error
Date
Msg-id 1090188828.25749.107.camel@linda
Whole thread Raw
In response to Function compile error  (Steve Tucknott <steve@retsol.co.uk>)
List pgsql-novice
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@lfix.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


pgsql-novice by date:

Previous
From: Steve Tucknott
Date:
Subject: Function compile error
Next
From: "Scott Marlowe"
Date:
Subject: Re: Calling Functions and Stored Procedures