Re: executing delete in a case statement? - Mailing list pgsql-general

From Christoph Dalitz
Subject Re: executing delete in a case statement?
Date
Msg-id 20021105140933.7dedd3e1.christoph.dalitz@hs-niederrhein.de
Whole thread Raw
In response to executing delete in a case statement?  (Jean-Christian Imbeault <jc@mega-bucks.co.jp>)
List pgsql-general
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" :-)

pgsql-general by date:

Previous
From: Christoph Dalitz
Date:
Subject: Re: [ADMIN] About lower and uppercase
Next
From: Richard Huxton
Date:
Subject: Re: log file?