select for update with left outer joins?
Is it expected that select for update doesn't work with left outer joins?
Just curious. I only need to lock one of the tables so far, so it's not a
problem.
Link.
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 ...
regards, tom lane
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.