From: Jens Hartwig <jens.hartwig@t-systems.de>
To: 'Richard Huxton' <dev@archonet.com>
Cc: 'PSQL-Sql \(E-Mail\)' <pgsql-sql@postgresql.org>
Subject: AW: Problems with RULE
Date: Wed, 7 Mar 2001 18:00:28 +0100
Message-ID: <001001c0a728$1cedf0a0$c10ac98a@0000864A433A> (raw)
In-Reply-To: <006701c0a6ec$3a60f7e0$1001a8c0@archonet.com>
> [...]
> So - if you issue "DELETE FROM t_xyz" you'd want two things to happen:
>
> 1. where deleted is false set it to true
> 2. where deleted was true delete the record
>
> So - PG rewrites the query into two parts:
>
> DELETE FROM t_xyz WHERE old.deleted=false
> DELETE FROM t_xyz WHERE NOT(old.deleted=false)
> [...]
Oooooh ... that's it! I hit my head against the wall :-)
Thank you very much!
Best regards, Jens Hartwig
-----------------------------------------------------
T-Systems
Projektleiter
debis Systemhaus GEI GmbH
Hausanschrift: Eichhornstraße 3, 10785 Berlin
Postanschrift: 10785 Berlin
Telefon: (004930) 25 54-32 82
Telefax: (004930) 25 54-31 87
Mobiltelefon: (0170) 167 26 48
E-Mail: jens.hartwig@t-systems.de
Internet: http://www.t-systems.de
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: jens.hartwig@t-systems.de, dev@archonet.com
Subject: Re: Problems with RULE
In-Reply-To: <001001c0a728$1cedf0a0$c10ac98a@0000864A433A>
References: <006701c0a6ec$3a60f7e0$1001a8c0@archonet.com> <001001c0a728$1cedf0a0$c10ac98a@0000864A433A>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox