Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings