Skip site navigation (1) Skip section navigation (2)

7.0.3: 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.0.3: order by func in union
Date: 2000-12-22 19:36:16
Message-ID: 8F4C99C66D04D4118F580090272A7A234D3215@sectorbase1.sectorbase.com (view raw or flat)
Thread:
Lists: pgsql-hackers
PostgreSQL 7.0.3 on sparc-sun-solaris2.6, compiled by gcc 2.95.2

drop table tryam;
create table tryam (x text);
insert into tryam values ('22');
insert into tryam values ('1');

test=# select x from tryam union select x from tryam;
 x  
----
 22
 1
(2 rows)

test=# select x from tryam union select x from tryam order by x;
 x  
----
 1
 22
(2 rows)

test=# select x from tryam union select x from tryam order by length(x);
 x  
----
 1
 22
 1
 22
(4 rows)

???

Vadim

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2000-12-22 20:01:06
Subject: Re: Inheritance is a security loophole!
Previous:From: Wilderman CerenDate: 2000-12-22 19:12:24
Subject: as i work BLOB's from PostODBC

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group