From: | "Zied Kharrat" <khzied(at)gmail(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Postgres-sql-php |
Date: | 2008-10-23 08:14:25 |
Message-ID: | 2c2d671c0810230114n7cb8e63bqc5a657d90bb8b4d5@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi Everybody..
Let's present my problem:
I have a table named *t1* and i will insert differents values like this :
insert into t1 (num,father,child,age) values ('1','joe','bruce','14',);
insert into t1 (num,father,child,age) values ('1','joe','lei','10',);
insert into t1 (num,father,child,age) values ('1','joe','mike','5',);
when i use select * from t1 i obtain:
*num father child age*
1 joe bruce 14
1 joe lei 10
1 joe mike 5
i want to have
*num father child age*
1 joe bruce 14
lei 10
mike 5
what can i do as select request to obtain this capture?
Thanks :)
From | Date | Subject | |
---|---|---|---|
Next Message | Aarni | 2008-10-23 10:00:01 | Re: SELECT multiple MAX(id)s ? |
Previous Message | Oleg Bartunov | 2008-10-23 06:52:12 | Re: Full Text Index Stats |