Re: Thoughts about updateable views - Mailing list pgsql-hackers

From Yann Michel
Subject Re: Thoughts about updateable views
Date
Msg-id 20041222130149.GA28011@zong.spline.inf.fu-berlin.de
Whole thread Raw
In response to Re: Thoughts about updateable views  (Richard Huxton <dev@archonet.com>)
Responses Re: Thoughts about updateable views
List pgsql-hackers
Hi,

On Wed, Dec 22, 2004 at 09:41:40AM +0000, Richard Huxton wrote:
> UNION etc doesn't necessarily mean you can't update, so long as the 
> underlying table/key can be identified.

I think you mean UNION ALL, i.e. the set addition, don't you?
Otherwise UNION (wothout ALL) is kind of a aggregation due to it only
adds a row once to the resulting set wheter it is found twice or not.
Therefore any updates are not possible.

Regards,
Yann


pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: oldish libpq bug still in RC2
Next
From: Richard Huxton
Date:
Subject: Re: Thoughts about updateable views