Does anyone know if there is a postgres shorthand for Oracle's (+) notation to denote an outer join?
eg
SELECT * from a, b where a.x = b.x (+)
Just the standard LEFT JOIN ... afaik
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
