Hour records within a date range - Mailing list pgsql-general

From sconeek@gmail.com
Subject Hour records within a date range
Date
Msg-id 1142285715.413656.39700@u72g2000cwu.googlegroups.com
Whole thread Raw
List pgsql-general
hi all,
i am trying to take a datefrom and dateto from a user and insert all
hour records within that date range within the db. eg, if the user
selects 2006-03-14 as datefrom and 2006-03-14 as dateto, the system
would insert 24 rows within the table with their corresponding
timestamps (eg 2006-03-14 01:00:00....2006-03-14 23:00:00).
any suggestions on how to do this. thanks.


pgsql-general by date:

Previous
From: "jia ding"
Date:
Subject: \copy combine with SELECT
Next
From: "Claudio Tognolo"
Date:
Subject: Disability the trigger