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 or flat)
Thread:
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                              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 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-2014 The PostgreSQL Global Development Group