| From: | David Stanaway <david(at)netventures(dot)com(dot)au> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Cc: | "lonh SENG" <slonh(at)camgsm(dot)com(dot)kh> |
| Subject: | Re: [ADMIN] SQL Script |
| Date: | 2002-01-30 02:08:23 |
| Message-ID: | 3D4F50BE-1526-11D6-BBC8-0003930FDAB2@netventures.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-sql |
On Wednesday, January 30, 2002, at 12:12 PM, 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
It looks like you are going to need to look into using a cursor, and
perl DBI or equiv. Alternatively, you could create a function in
PL/PGSQL.
Where do you get the date for the end of the interval for the last
inbtime ordered by time?
==============================
David Stanaway
Personal: david(at)stanaway(dot)net
Work: david(at)netventures(dot)com(dot)au
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2002-01-30 02:14:15 | Re: SQL Script |
| Previous Message | GB Clark | 2002-01-30 01:37:54 | Re: Sample database for me to practice with? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2002-01-30 02:14:15 | Re: SQL Script |
| Previous Message | lonh SENG | 2002-01-30 01:12:32 | SQL Script |