Re: pl/pgsql trigger: syntax error at or near "ELSEIF"

From: Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)cz>
To: Roman Neuhauser <neuhauser(at)chello(dot)cz>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pl/pgsql trigger: syntax error at or near "ELSEIF"
Date: 2005-01-14 12:26:07
Message-ID: Pine.LNX.4.44.0501141325460.2217-100000@kix.fsv.cvut.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello

try

35.7.2.4. IF-THEN-ELSIF-ELSE

IF boolean-expression THEN
statements
[ ELSIF boolean-expression THEN
statements
[ ELSIF boolean-expression THEN
statements
...]]
[ ELSE
statements ]
END IF;

regards
Pavel

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2005-01-14 12:27:24 Re: pl/pgsql trigger: syntax error at or near "ELSEIF"
Previous Message Jiří Němec 2005-01-14 12:19:53 Insufficient system resources for PostgreSQL 7.4.x?