Thread: 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.