Re: create function problem

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: Gary Stainburn <gary(dot)stainburn(at)ringways(dot)co(dot)uk>, pgsql-sql(at)postgresql(dot)org
Subject: Re: create function problem
Date: 2010-12-30 17:47:09
Message-ID: 4D1CC59D.4030805@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(dot)klaver(at)gmail(dot)com

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Gary Stainburn 2010-12-30 20:16:02 Re: create function problem
Previous Message Pavel Stehule 2010-12-30 17:35:16 Re: create function problem