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

order by and union

From: Benoit Lion <Benoit(dot)Lion(at)ac-grenoble(dot)fr>
To: pgsql-bugs(at)postgresql(dot)org
Subject: order by and union
Date: 2001-07-04 14:11:38
Message-ID: 3B43241A.B46788CD@ac-grenoble.fr (view raw or flat)
Thread:
Lists: pgsql-bugs
In postgres 7.0.2 i have an "order by" with column names like this :

select colonne1,colonne2 from A
union
select colonne1,colonne2 from B

	order by colonne1,colonne2   

In postgres 7.1 this simple example works. But with i have a more
difficult select that doesn't work, and i had to use the number column
to get a good result

This is my real example :

select nmn_can,pre_can,dat_nai,dci_sai,cnd.cod_spe,cnd.cod_pa1,decision
, cnd.cod_pa2 
from  cnd,cnd_grp, decision where cnd.cod_eta='0731043M' 
and cnd.num_can=cnd_grp.num_can and cnd_grp.typ_grp='D' 
and cnd_grp.dci_sai=decision.cod_dec 

union 

select nmn_can,pre_can,dat_nai,dci_sai,cnd.cod_spe,cnd.cod_pa1,decision
, cnd.cod_pa2 
from cnd,cnd_grp, decision where cnd.num_can=cnd_grp.num_can and
cnd_grp.typ_grp='D' 
and cnd_grp.dci_sai=decision.cod_dec and cnd.cod_cat='520' 
and cnd.cod_eta in ( select cod_aff from affichage where
cod_eta='0731043M' and cnd.cod_spe=affichage.cod_spe) 

order by cnd.cod_spe, cnd.cod_pa1,decision,nmn_can

so i replace the orber by :

order by 5,6,7,1


Benoit Lion - Inspection Académique de Chambéry - tel :04 79 62 53 19
France

Responses

pgsql-bugs by date

Next:From: Vadim I. PassynkovDate: 2001-07-04 17:26:36
Subject: Simple recursion function on plpgsql - Postgresql 7.1
Previous:From: Nico VaesDate: 2001-07-04 07:34:38
Subject: Databases in Belgium

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