7.1current: order by func in union
Started by Mikheev, Vadimabout 25 years ago2 messages
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
Re: 7.1current: order by func in union
"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