| From: | javier garcia - CEBAS <rn001(at)cebas(dot)csic(dot)es> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | date question |
| Date: | 2003-06-13 11:44:09 |
| Message-ID: | 200306131130.h5DBUiI06008@natura.cebas.csic.es |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Albrecht Berger | 2003-06-13 11:50:54 | trigger : emulate "instead of" with before ? |
| Previous Message | Tomasz Myrta | 2003-06-13 06:00:04 | Re: question on rules |