Re: select for update with left outer joins? - Mailing list pgsql-general

From Lincoln Yeoh
Subject Re: select for update with left outer joins?
Date
Msg-id 5.1.0.14.1.20030105185853.00a71d10@mbox.jaring.my
Whole thread Raw
In response to Re: select for update with left outer joins?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
At 11:09 AM 1/4/03 -0500, Tom Lane wrote:

>Lincoln Yeoh <lyeoh@pop.jaring.my> writes:
> > Is it expected that select for update doesn't work with left outer joins?
>
>What would you consider the semantics to be?  I am not sure how to lock
>the absence of a matching row ...

How about rows returned from the "left" table and those returned from the
"right" table excluding nulls?

Have I got some concept wrong (SQL or other)? e.g. If I got it right I
wouldn't be asking this :).

Happy New Year!
Link.


pgsql-general by date:

Previous
From: Oliver Vecernik
Date:
Subject: refcursor
Next
From: Timur Irmatov
Date:
Subject: foreign key locks