At 11:09 AM 1/4/03 -0500, Tom Lane wrote:
>Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)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.