On Fri, 11 Mar 2005 11:36 pm, Steven Verhoeven wrote: > Hi all > > My table definition : > > id | fref | mref > ------+-----------+---------- > 1 | 23 | 25 > 2 | 24 | 28 > 3 | 25 | 31 > 4 | 26 | 34 > > My problem : > i need a query that results in this : > > id | ref > ------+---------- > 1 | 23 > 1 | 25 > 2 | 24 > 2 | 28 > 3 | 25 > 3 | 31 > 4 | 26 > 4 | 34 > SELECT id, fref as ref FROM table UNION ALL SELECT id, mref as ref FROM table;
Should do the trick. > > Do I need a crosstab-query ? > Who can help me ? > > ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match