Postgres Pro
Downloads
Home   >   mailing lists

Re: create function problem - Mailing list pgsql-sql

From Adrian Klaver
Subject Re: create function problem
Date
Msg-id 4D1CC59D.4030805@gmail.com
Whole thread Raw
In response to Re: create function problem  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: create function problem
List pgsql-sql
Tree view 
On 12/30/2010 09:35 AM, Pavel Stehule wrote:
> Hello
>
> you badly use a IF statement. It's not C. Every IF must to finish with END IF
>
> this is
>
> IF .. THEN
> ELSEIF .. THEN ..
> ELSE
> END IF
>
> Regards
>
> Pavel Stehule

To follow up I think the OP was looking for ELSEIF not ELSE IF. Changing 
the ELSE IF to ELSEIF should fix it.


-- 
Adrian Klaver
adrian.klaver@gmail.com

pgsql-sql by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: create function problem
Next
From: Gary Stainburn
Date:
Subject: Re: create function problem