| From: | Manfred Koizar <mkoi-pg(at)aon(dot)at> |
|---|---|
| To: | Jan Wieck <JanWieck(at)Yahoo(dot)com> |
| Cc: | Greg Stark <gsstark(at)mit(dot)edu>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Updateable Views? |
| Date: | 2004-08-10 00:13:33 |
| Message-ID: | sq2gh0dped68u8boc7r5dv25n6en8pf3r4@email.aon.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
On Sat, 07 Aug 2004 10:24:34 -0400, Jan Wieck <JanWieck(at)Yahoo(dot)com>
wrote:
>I have not heard of "updatable subselects" yet.
| Here we update a join. [...]
| scott(at)ORA734(dot)WORLD> update
| 2 ( select columnName, value
| 3 from name, lookup
| 4 where name.keyname = lookup.keyname
| 5 and lookup.otherColumn = :other_value )
| 6 set columnName = value
| 7 /
Google for
oracle "delete statement" syntax
or
oracle "update statement" syntax
Servus
Manfred
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc G. Fournier | 2004-08-10 00:36:52 | PostgreSQL 8.0.0 Officially Goes Beta |
| Previous Message | Patrick Vachon | 2004-08-09 21:13:24 | Implicit join |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-08-10 00:22:11 | Re: Tablespace issues (comment on ,moving indexes) |
| Previous Message | Tom Lane | 2004-08-10 00:12:38 | Re: Tablespace issues (comment on ,moving indexes) |