X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 9DCC330EB0E for ; Fri, 13 Jun 2003 11:44:34 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 15274-09 for ; Fri, 13 Jun 2003 08:44:24 -0300 (ADT) Received: from natura.cebas.csic.es (natura.cebas.csic.es [161.111.146.9]) by svr1.postgresql.org (Postfix) with ESMTP id 3552630EB02 for ; Fri, 13 Jun 2003 08:44:23 -0300 (ADT) Received: from natura.cebas.csic.es (localhost.localdomain [127.0.0.1]) by natura.cebas.csic.es (8.11.6/8.11.6) with ESMTP id h5DBUjo06014 for ; Fri, 13 Jun 2003 13:30:45 +0200 Received: from there (equipo97.cebas.csic.es [161.111.146.97]) by natura.cebas.csic.es (8.11.6/8.11.6) with SMTP id h5DBUiI06008 for ; Fri, 13 Jun 2003 13:30:44 +0200 Message-Id: <200306131130.h5DBUiI06008@natura.cebas.csic.es> Content-Type: text/plain; charset="iso-8859-15" From: javier garcia - CEBAS Organization: CEBAS-CSIC To: pgsql-sql@postgresql.org Subject: date question Date: Fri, 13 Jun 2003 13:44:09 +0200 X-Mailer: KMail [version 1.3.2] MIME-Version: 1.0 Content-Transfer-Encoding: 8bit X-Spam-Status: No, hits=0.7 tagged_above=0.0 required=5.0 tests=FROM_ENDS_IN_NUMS X-Spam-Level: * X-Archive-Number: 200306/151 X-Sequence-Number: 13909 Hi; I've got a table in the way: year | month | day | est7237 | est7238 | est7239 | est7250 ------+-------+-----+---------+---------+---------+--------- 2002 | 9 | 1 | | | | 2002 | 9 | 2 | | | | 2002 | 9 | 3 | | | | ... This table is: murciadb=# \d series_lluvia_completas Table "series_lluvia_completas" Column | Type | Modifiers ---------+---------+----------- year | integer | month | integer | day | integer | est7237 | real | est7238 | real | est7239 | real | est7250 | real | And I've got another related tables with a date field. I need to compare the dates field in the other tables with "year", "month", "day" in this table. Is there a way to create a table from this table, directly in Postgres in which a date field is created based in the values of "year", "month", "day" in this table? Thanks and regards Javier