From: | Jan Wieck <JanWieck(at)Yahoo(dot)com> |
---|---|
To: | Greg Stark <gsstark(at)mit(dot)edu> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Updateable Views? |
Date: | 2004-08-07 14:24:34 |
Message-ID: | 4114E622.7070306@Yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
On 8/3/2004 11:38 PM, Greg Stark wrote:
> "Scott Marlowe" <smarlowe(at)qwest(dot)net> writes:
>
>> On Tue, 2004-08-03 at 13:05, CSN wrote:
>> > Just wondering, is updateable views slated for a
>> > future version of Postgresql? In addition to using
>> > rules that is.
>>
>> I would think that a basic fleshing out of the logic with some kind of
>> stored proc to make the views and triggers would likely get someone
>> started on the backend work. You know, a proof of concept thingy.
>
> I have some fears here. It seems everyone's first thought when they think
> about updateable views is to think about constructing rules on the views.
>
> How would that approach help with inline views? Things like:
>
> UPDATE (SELECT a+b AS x, c AS y FROM foo) SET c=1 WHERE x = 10
There is no such thing as an "inline view". What you show here is a
subselect, and I have not heard of "updatable subselects" yet. Could you
point me to the section in the ANSI SQL specifications that describes
this feature please?
Jan
>
> It seems like starting with these types of views in the backend would be more
> productive than implementing something in rules. Once postgres can handle
> inline views it should be trivial to handle persistent views just like they're
> handled on selects.
>
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #
From | Date | Subject | |
---|---|---|---|
Next Message | Mike Nolan | 2004-08-07 15:00:11 | Re: Rounding in PGSQL |
Previous Message | Jiri Nemec | 2004-08-07 14:16:54 | Rounding in PGSQL |
From | Date | Subject | |
---|---|---|---|
Next Message | Bernd Helmle | 2004-08-07 15:34:54 | Backend crashes with notification rule |
Previous Message | John Hansen | 2004-08-07 13:40:36 | Re: [PATCHES] UNICODE characters above 0x10000 |