Re: Create a new table

From: sconeek(at)gmail(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Create a new table
Date: 2006-03-13 04:18:43
Message-ID: 1142223523.361476.321890@v46g2000cwv.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

i just had this thought.
i should take both dates, subtract them and multiply the figure by 24.
then i should insert that many rows with their individual timestamps
into the table in a sequential order.
eg 2005-12-12 12:00:00
2005-12-13 01:00:00 and so on.

can somebody please guide me in this.
thanks.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message sconeek 2006-03-13 06:09:14 URGENT!!! SELECT statement please help
Previous Message sconeek 2006-03-13 02:46:00 Create a new table