----- Original Message ----- From: Vincent HikidaTo: Steven Verhoeven ; pgsql-general@postgresql.org ; pgsql-novice@postgresql.orgSent: Sunday, March 13, 2005 6:34 PMSubject: Re: [NOVICE] [GENERAL] sql questionSELECT t1.id , t1.fref FROM t1UNION ALLSELECT t2.id , t2.mref FROM t2 ----- Original Message ----- From: Steven VerhoevenTo: pgsql-general@postgresql.org ; pgsql-novice@postgresql.orgSent: Friday, March 11, 2005 4:36 AMSubject: [GENERAL] sql questionHi all My table definition : id | fref | mref------+-----------+---------- 1 | 23 | 25 2 | 24 | 28 3 | 25 | 31 4 | 26 | 34My 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 | 34Do I need a crosstab-query ?Who can help me ?-- A computer is like an airconditioner. When windows open, it stops working ! -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Steven Verhoeven, ICT Support Engineer Department for Molecular Biomedical Research (DMBR)VIB - Ghent University 'Fiers-Schell-Van Montagu' buildingTechnologiepark 927B - 9052 Ghent (Zwijnaarde)BelgiumTel : +32-(0)9-33-13.606 Fax : +32-(0)9-33-13.609E-mail : Steven.Verhoeven@dmbr.UGent.beURL : http://www.dmbr.UGent.be
----- Original Message ----- From: Steven VerhoevenTo: pgsql-general@postgresql.org ; pgsql-novice@postgresql.orgSent: Friday, March 11, 2005 4:36 AMSubject: [GENERAL] sql questionHi all My table definition : id | fref | mref------+-----------+---------- 1 | 23 | 25 2 | 24 | 28 3 | 25 | 31 4 | 26 | 34My 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 | 34Do I need a crosstab-query ?Who can help me ?-- A computer is like an airconditioner. When windows open, it stops working ! -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Steven Verhoeven, ICT Support Engineer Department for Molecular Biomedical Research (DMBR)VIB - Ghent University 'Fiers-Schell-Van Montagu' buildingTechnologiepark 927B - 9052 Ghent (Zwijnaarde)BelgiumTel : +32-(0)9-33-13.606 Fax : +32-(0)9-33-13.609E-mail : Steven.Verhoeven@dmbr.UGent.beURL : http://www.dmbr.UGent.be
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Steven Verhoeven, ICT Support Engineer
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных