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