Re: ORDER BY col is NULL in UNION causes error?

Tom Lane wrote:
> Bruce Momjian <bruce@momjian.us> 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@momjian.us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +