Thank all of you very much. It works now. ----- Original Message ----- From: "Stephan Szabo" <[EMAIL PROTECTED]> To: "lonh SENG" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> 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 > > ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
