| 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: | Whole Thread | Raw Message | 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 |