Bruce Momjian <[EMAIL PROTECTED]> writes: > Well, it can be an expression _if_ the expression _matches_ an existing > UNION column.
You're mistaken. It has to be *an output column name*. Not anything else.
regards, tom lane
---------------------------(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
