7.1current: order by func in union

From: "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM>
To: "'pgsql-hackers(at)postgresql(dot)org'" <pgsql-hackers(at)postgresql(dot)org>
Subject: 7.1current: order by func in union
Date: 2000-12-22 20:14:08
Message-ID: 8F4C99C66D04D4118F580090272A7A234D3216@sectorbase1.sectorbase.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2000-12-22 21:53:24 Re: 7.1current: order by func in union
Previous Message Bruce Momjian 2000-12-22 20:01:06 Re: Inheritance is a security loophole!