Re: pl/pgsql oddity

From: Ian Barwick <barwick(at)gmail(dot)com>
To: Joolz <joolz(at)arbodienst-limburg(dot)nl>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pl/pgsql oddity
Date: 2004-12-16 09:23:40
Message-ID: 1d581afe04121601235a3a4706@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 16 Dec 2004 10:06:19 +0100 (CET), Joolz
<joolz(at)arbodienst-limburg(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2004-12-16 09:23:42 Re: Insert do not work in my case
Previous Message Matteo Beccati 2004-12-16 09:20:14 Re: pl/pgsql oddity