Re: nested elseif woes

Поиск
Список
Период
Сортировка
От Ivan Sergio Borgonovo
Тема Re: nested elseif woes
Дата
Msg-id 20040511005855.3e416829@stige.webthatworks.it
обсуждение исходный текст
Ответ на Re: nested elseif woes  (Kris Jurka <books@ejurka.com>)
Ответы Re: nested elseif woes  (Steve Atkins <steve@blighty.com>)
Postgres demo app [was: Re: nested elseif woes]  (Rory Campbell-Lange <rory@campbell-lange.net>)
Список 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 по дате отправления:

Предыдущее
От: Rory Campbell-Lange
Дата:
Сообщение: Re: Very slow query
Следующее
От: Nick Barr
Дата:
Сообщение: Re: Very slow query