Date: Tue, 5 Nov 2002 10:42:21 +0000
From: Richard Huxton <dev@archonet.com>
On Tuesday 05 Nov 2002 10:03 am, Jean-Christian Imbeault wrote:
> > What is the proper way to execute a delete statement (if possible) in a
> > case statement.
>
> The "case" is supposed to be returning a value not taking actions. SQL is not
> a procedural language like C/Perl/PHP etc.
>
Actually PostgreSQL ships with a procedural extension of SQL!
Check the docs for PL/pgSQL.
Christoph Dalitz
PS: I guess that your emails will land in the spam folder of most people
due to your email address "mega-bucks" :-)