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

From Mikheev, Vadim
Subject 7.1current: order by func in union
Date
Msg-id 8F4C99C66D04D4118F580090272A7A234D3216@sectorbase1.sectorbase.com
Whole thread Raw
Responses Re: 7.1current: order by func in union  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> 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


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Inheritance is a security loophole!
Next
From: Tom Lane
Date:
Subject: Re: 7.1current: order by func in union