Skip site navigation (1) Skip section navigation (2)

Re: Function compile error

From: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
To: steve(at)retsol(dot)co(dot)uk
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Function compile error
Date: 2004-07-18 22:13:48
Message-ID: 1090188828.25749.107.camel@linda (view raw, whole thread or download thread mbox)
Lists: 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(at)lfix(dot)co(dot)uk
Isle of Wight                    
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 MarloweDate: 2004-07-18 22:39:12
Subject: Re: Calling Functions and Stored Procedures
Previous:From: Josh BerkusDate: 2004-07-18 20:09:23
Subject: Re: SQL - Indexing for performance on uniquness check...

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group