X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id CFD9AD1E88A for ; Wed, 21 Jan 2004 09:15:13 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 75617-08 for ; Wed, 21 Jan 2004 05:14:43 -0400 (AST) Received: from domino.nc.com.my (domino.nc.com.my [202.185.214.131]) by svr1.postgresql.org (Postfix) with ESMTP id C01DFD1E90E for ; Wed, 21 Jan 2004 05:14:40 -0400 (AST) Subject: time series data To: pgsql-sql@postgresql.org X-Mailer: Lotus Notes Release 5.0 (Intl) 30 March 1999 Message-ID: From: azwa@nc.com.my Date: Wed, 21 Jan 2004 16:53:11 +0800 X-MIMETrack: Serialize by Router on domino/ANSI(Release 5.0.5 |September 22, 2000) at 01/21/2004 04:53:19 PM, Serialize complete at 01/21/2004 04:53:19 PM MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="=_alternative 0032F94D48256E22_=" X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.3 tagged_above=0.0 required=5.0 tests=BAYES_30, HTML_50_60, NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200401/191 X-Sequence-Number: 16584 This is a multipart message in MIME format. --=_alternative 0032F94D48256E22_= Content-Type: text/plain; charset="us-ascii" 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. --=_alternative 0032F94D48256E22_= Content-Type: text/html; charset="us-ascii"

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. --=_alternative 0032F94D48256E22_=--