select for update with left outer joins? 
Author Message
 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.

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.***.com/



Wed, 22 Jun 2005 21:15:31 GMT
 select for update with left outer joins?

Quote:

> 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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html



Thu, 23 Jun 2005 00:10:14 GMT
 select for update with left outer joins?

Quote:

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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command



Thu, 23 Jun 2005 18:57:25 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. LEFT OUTER LOOP JOIN and LEFT OUTER JOIN

2. LEFT JOIN and LEFT OUTER JOIN

3. LEFT JOIN and LEFT OUTER JOIN

4. Left outer join works, Right outer join just goes on for ever, processor at 100%

5. Left-Outer join and Right-Outer join

6. Combination of LEFT OUTER JOIN, sub-select and OR in WHERE clause fails

7. LEFT OUTER JOIN vs RIGHT OUTER JION

8. LEFT OUTER JOIN faster than INNER JOIN?

9. left outer join on Inner join

10. Here is a challenge: 2 inner joins and 1 left outer join

11. Left Outer join on Inner join

12. Outer Joins and Select ... for update of statements


 
Powered by phpBB® Forum Software