On Mon, 29 Aug 2005, Christian Almeida wrote:
> Should this sql work?
Yes and no. ;) Whether this errors or adds the reference is controlled by
a configuration variable, add_missing_from. For backwards compatibility
reasons (and for allowing outside table references in delete) the variable
currently defaults to on IIRC. At some point in the future the default
will likely change to off.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
