| From: | Christoph Dalitz <christoph(dot)dalitz(at)hs-niederrhein(dot)de> |
|---|---|
| To: | Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: executing delete in a case statement? |
| Date: | 2002-11-05 13:09:33 |
| Message-ID: | 20021105140933.7dedd3e1.christoph.dalitz@hs-niederrhein.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Date: Tue, 5 Nov 2002 10:42:21 +0000
From: Richard Huxton <dev(at)archonet(dot)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" :-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2002-11-05 13:17:04 | Re: log file? |
| Previous Message | Christoph Dalitz | 2002-11-05 13:01:03 | Re: [ADMIN] About lower and uppercase |