Tom Lane wrote: > Bruce Momjian <bruce@xxxxxxxxxx> writes: > > 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 does not meet the style guidelines. Where are the style guidelines? I looked before but can't find them. I agree the second part could be a hint. -- Bruce Momjian bruce@xxxxxxxxxx EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +