Re: nested elseif woes

From: Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: nested elseif woes
Date: 2004-05-10 22:58:55
Message-ID: 20040511005855.3e416829@stige.webthatworks.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 10 May 2004 13:56:39 -0500 (EST)
Kris Jurka <books(at)ejurka(dot)com> wrote:

> On Mon, 10 May 2004, Ivan Sergio Borgonovo wrote:
>
> > Now let's come to the problem:
> >
> > create or replace function testa( )
> > returns char(32) as
> > '
> > begin
> > if 1=2 then
> > if 1=2 then
> > select 1;
> > elseif 1=3 then
> > select 2;
> > elseif 1=4 then
>
> Don't you mean ELSIF, not ELSEIF?

thanks to everyone.
Curiously enough, trying to figure out what was wrong with my code,
I've been able to write versions with the wrong spelling that didn't
complain. That brought me astray.

Anyway does anyone know any public big enough project written in
plpgsql from which I could learn lurking at the code?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nick Barr 2004-05-10 23:09:23 Re: Very slow query
Previous Message Rory Campbell-Lange 2004-05-10 21:30:03 Re: Very slow query