Postgres Pro
Downloads
Home   >   mailing lists

Re: 7.1current: order by func in union - Mailing list pgsql-hackers

From Tom Lane
Subject Re: 7.1current: order by func in union
Date
Msg-id 19806.977522004@sss.pgh.pa.us
Whole thread Raw
In response to 7.1current: order by func in union  ("Mikheev, Vadim" <vmikheev@SECTORBASE.COM>)
List pgsql-hackers
Tree view 
"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

pgsql-hackers by date:

Previous
From: "Mikheev, Vadim"
Date:
Subject: 7.1current: order by func in union
Next
From: Ed Loehr
Date:
Subject: GEQO status?