From: azwa@nc.com.my
To: pgsql-sql@postgresql.org
Subject: Re: time series data
Date: Tue, 27 Jan 2004 09:42:27 +0800
Message-ID: <OF9F6AE314.E3F8364A-ONFFFFFF56.0024DC53@nc.com.my> (raw)
Hi,
thanks for the info..btw can u pls explain a little bit detail since i
can't get thru yr solution.
thanks in advance
Dnia 2004-01-21 10:37, Użytkownik Tomasz Myrta napisał:
> Use this integer sequence and interval datatype to get date result:
> your_date='1994-01-01'::date+'1 day'::integer * time_key
^^^^^^^
Sorry, use interval here.
Regards,
Tomasz Myrta
azwa@postgresql.org
Sent by: pgsql-sql-owner@postgresql.org
01/21/2004 04:53 PM
To: pgsql-sql@postgresql.org
cc:
Subject: [SQL] time series data
Hi,
i want to create time table & the structure as below :
Column
Type
Modifiers
time_key
yr_id
month_id
month_desc
day_id
integer
integer
integer
text
integer
not null default nextval('time_seq'::text)
Example of data in time table:
Time_key
yr_id
month_id
month_desc
day_id
1999
1
Jan
1
1999
1
Jan
2
2000
1
Jan
1
time_key data will keep increment reading from sequence. i'm going to have
a data from yr_id =1994 --> 2009 , month_id =1 -->12
and day_id =1 -->31 for each month. So is there any solution (using
function, or else) that can give me the above data
in Postgresql??.
thanks in advance.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: azwa@nc.com.my
Subject: Re: time series data
In-Reply-To: <OF9F6AE314.E3F8364A-ONFFFFFF56.0024DC53@nc.com.my>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox