Groups > comp.databases.postgresql > #909

Re: ORDER BY in UNION in postgres 7.3.9

Newsgroups	comp.databases.postgresql
Date	2022-08-22 22:45 -0700
References	<1il71je.1aqj8b06n3djgN%mackel@fixe-post.de> <1217927275.727968@proxy.dienste.wien.at> <1il7a7w.fhjljgkoowN%mackel@fixe-post.de>
Message-ID	<d496c866-fa48-4ff8-be18-9d2306a9cbfbn@googlegroups.com> (permalink)
Subject	Re: ORDER BY in UNION in postgres 7.3.9
From	paedru fernando <paedru.fernando@gmail.com>

Show all headers | View raw

On Tuesday, August 5, 2008 at 4:18:48 PM UTC+5:30, Robert Welz wrote:
> Laurenz Albe <inv...@spam.to.invalid> wrote:
> ...
> > 
> > SELECT * FROM (SELECT * FROM a UNION SELECT * FROM b) dummy
> > ORDER BY upper(val);
> > 
> > id | val 
> > ----+-------------
> > 1 | one
> > 1 | ONE HUNDRED
> > 2 | two
> > 2 | TWO HUNDRED
> > (4 rows)
> > 
> > There you go!
> > 
> > Yours,
> > Laurenz Albe
> Great! Thank you very much!
> Robert
...........................................


Great solution!! Thanks - Laurenz Albe . IF you ever be to India (Tamilnadu).  your beer's on me.

Back to comp.databases.postgresql | Previous | Next | Find similar

Thread

Re: ORDER BY in UNION in postgres 7.3.9 paedru fernando <paedru.fernando@gmail.com> - 2022-08-22 22:45 -0700

csiph-web