Bruce Momjian wrote: > Here the column result is an expression, and you reference that. > Updated wording: > > test=> select * from test union select * from test order by x is null; > ERROR: A UNION/INTERSECT/EXCEPT ORDER BY cannot use expressions or > functions, only result column names
This seems at odds with our message style guidelines. I'd suggest putting the actual error message in errmsg() and the rest as a errhint, maybe (errmsg("invalid UNION/INTERSECT/EXCEPT ORDER BY clause"), errhint("You may specify only output result column names in the ORDER BY clauses.")) or something like that. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly