Re: Compile error in function - Mailing list pgsql-novice

From big_mafa
Subject Re: Compile error in function
Date
Msg-id 004201c36432$17a88b90$1701a8c0@attila
Whole thread Raw
In response to Re: Compile error in function  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-novice
Hi Stephan,

Thanks for your very fast answer - of course, the begin was the problem...

Koszonom!

Regards: Attila


----- Original Message -----
From: "Stephan Szabo" <sszabo@megazone.bigpanda.com>
To: "big_mafa" <big_mafa@freemail.hu>
Cc: <pgsql-novice@postgresql.org>
Sent: Saturday, August 16, 2003 9:49 PM
Subject: Re: [NOVICE] Compile error in function


>
> On Sat, 16 Aug 2003, big_mafa wrote:
>
> > There is a very annoying problem.
> > I created a very simple function, which can be created well, but if I
call
> > it, the following problem occurs:
>
> The function isn't checked until first run.
>
> > ERROR:  parse error at or near "IF"
> > WARNING:  plpgsql: ERROR during compile of cre_kitchen_log near line 1
> >
> > The Function is:
> >
> > CREATE OR REPLACE FUNCTION "public"."cre_kitchen_log" (date) RETURNS
integer
> > AS'
>
> You need a BEGIN here.



pgsql-novice by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Compile error in function
Next
From: "Wayne M. Syvinski"
Date:
Subject: a: queries across databases b: plperl