Re: Updateable Views? - Mailing list pgsql-hackers

From Manfred Koizar
Subject Re: Updateable Views?
Date
Msg-id sq2gh0dped68u8boc7r5dv25n6en8pf3r4@email.aon.at
Whole thread Raw
In response to Re: Updateable Views?  (Jan Wieck <JanWieck@Yahoo.com>)
List pgsql-hackers
On Sat, 07 Aug 2004 10:24:34 -0400, Jan Wieck <JanWieck@Yahoo.com>
wrote:
>I have not heard of "updatable subselects" yet.


http://asktom.oracle.com/pls/ask/f?p=4950:8:6693556430011788783::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:273215737113,

| Here we update a join. [...]
| scott@ORA734.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 fororacle "delete statement" syntax
ororacle "update statement" syntax

ServusManfred


pgsql-hackers by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: Beta Page on Developer's site is out of date
Next
From: Tom Lane
Date:
Subject: Re: Tablespace issues (comment on ,moving indexes)