Re: executing delete in a case statement?

Date: Tue, 5 Nov 2002 10:42:21 +0000
From: Richard Huxton 

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" :-)