From: | "Jens Hartwig" <jens(dot)hartwig(at)t-systems(dot)de> |
---|---|
To: | "'Richard Huxton'" <dev(at)archonet(dot)com> |
Cc: | "'PSQL-Sql \(E-Mail\)'" <pgsql-sql(at)postgresql(dot)org> |
Subject: | AW: Problems with RULE |
Date: | 2001-03-07 17:00:28 |
Message-ID: | 001001c0a728$1cedf0a0$c10ac98a@0000864A433A |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
> [...]
> 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(dot)hartwig(at)t-systems(dot)de
Internet: http://www.t-systems.de
From | Date | Subject | |
---|---|---|---|
Next Message | Jie Liang | 2001-03-07 17:09:32 | how to get info of function |
Previous Message | Thomas Lockhart | 2001-03-07 16:57:27 | Re: No Documentation for to_char(INTERVAL, mask) |