Re: SELECT updatability clause defective. - Mailing list pgsql-bugs

From Tom Lane
Subject Re: SELECT updatability clause defective.
Date
Msg-id 4315.989589461@sss.pgh.pa.us
Whole thread Raw
In response to RE: SELECT updatability clause defective.  ("Jerome O'Neil" <joneil@combimatrix.com>)
List pgsql-bugs
"Jerome O'Neil" <joneil@combimatrix.com> writes:
> Which makes me wonder:  What is the point, if not to
> restrict updatability?

Postgres' SELECT FOR UPDATE marks rows for update, not columns.
Thus nominating columns in it would make no sense.

It was probably an unfortunate decision to use "FOR UPDATE" as
the syntax for this feature, since the spec uses that phrase
to deal with something completely different.  But we're not gonna
change it now, especially since it's not getting in the way of
adding support for the spec's feature.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Alter table add column ignores default
Next
From: Thomas Lockhart
Date:
Subject: Re: createdb test shown as number in data directory