Thank all of you very much. It works now.
----- Original Message -----
From: "Stephan Szabo" <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: "lonh SENG" <slonh(at)camgsm(dot)com(dot)kh>
Cc: <pgsql-admin(at)postgresql(dot)org>
Sent: Wednesday, January 30, 2002 9:14 AM
Subject: Re: [ADMIN] SQL Script
>
> On Wed, 30 Jan 2002, lonh SENG wrote:
>
> > Hi all,
> >
> > I have one table containing data as "source.txt" attached file. I
> > want to create a script to clean the data and get the result as
> > "result.txt" attached file.
> > inbtime and inbtime1 is datetime data type.
> > Anyone has an idea?
> > Any help will be appreciated.
> > thanks in advance
> >
> > Sorry. It seems to be out of the topic.
>
> Probably belongs on pgsql-sql, but... :)
>
> This is not at all optimized, but maybe something of the form:
>
> select t1.card, t1.inbtime, coalesce((select min(inbtime) from t t2 where
> t2.inbtime>t1.inbtime and t2.card=t1.card), t1.inbtime) from t t1;
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
>