Re: nested elseif woes - Mailing list pgsql-general

From Ivan Sergio Borgonovo
Subject Re: nested elseif woes
Date
Msg-id 20040511005855.3e416829@stige.webthatworks.it
Whole thread Raw
In response to Re: nested elseif woes  (Kris Jurka <books@ejurka.com>)
Responses Re: nested elseif woes  (Steve Atkins <steve@blighty.com>)
Postgres demo app [was: Re: nested elseif woes]  (Rory Campbell-Lange <rory@campbell-lange.net>)
List pgsql-general
On Mon, 10 May 2004 13:56:39 -0500 (EST)
Kris Jurka <books@ejurka.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?


pgsql-general by date:

Previous
From: Rory Campbell-Lange
Date:
Subject: Re: Very slow query
Next
From: Nick Barr
Date:
Subject: Re: Very slow query