| 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: | Whole Thread | Raw Message | 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?
| 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 |