[SQL] Postgres-sql-php

[Zied Kharrat]

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 :)