Thread: 7.1current: order by func in union

> PostgreSQL 7.0.3 on sparc-sun-solaris2.6, compiled by gcc 2.95.2
...
> test=# select x from tryam union select x from tryam order by 
> length(x);
>  x  
> ----
>  1
>  22
>  1
>  22
> (4 rows)

7.1current:

vac=# select x from tryam union select x from tryam order by length(x);
ERROR:  Attribute 'x' not found

Vadim

"Mikheev, Vadim" <vmikheev@SECTORBASE.COM> writes:
> vac=# select x from tryam union select x from tryam order by length(x);
> ERROR:  Attribute 'x' not found

The UNION code doesn't support ordering by resjunk attributes, and never
has (but 7.1 at least knows it can't do it ;-)).  Something to fix when
we redesign querytrees.
        regards, tom lane