Postgres-sql-php

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

Responses

Browse pgsql-sql by date

  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