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
