Re: pl/pgsql oddity - Mailing list pgsql-general

From Ian Barwick
Subject Re: pl/pgsql oddity
Date
Msg-id 1d581afe04121601235a3a4706@mail.gmail.com
Whole thread Raw
In response to pl/pgsql oddity  ("Joolz" <joolz@arbodienst-limburg.nl>)
Responses Re: pl/pgsql oddity  ("Joolz" <joolz@arbodienst-limburg.nl>)
List pgsql-general
On Thu, 16 Dec 2004 10:06:19 +0100 (CET), Joolz
<joolz@arbodienst-limburg.nl> wrote:
> Hello everyone,
>
> When writing some serverside code I ran into an oddity that I
> managed to boil down to this:
>
> -------------------------------------------------------
> create or replace function fubar() returns varchar as '
> declare
>   l integer;
> begin
>   l = 38;
>   if l < 38 then
>     return ''< 38'';
>   elseif l >= 38 then

Try "elsif" here.
(No, I don't know what the problem with "elseif" is).

Ian Barwick

pgsql-general by date:

Previous
From: Matteo Beccati
Date:
Subject: Re: pl/pgsql oddity
Next
From: Richard Huxton
Date:
Subject: Re: Insert do not work in my case