Re: Compile error in function

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.