On Fri, Jun 20, 2003 at 19:33:35 +0200, javier garcia - CEBAS <rn001@cebas.csic.es> wrote:
> Hi all;
>
> Peter, thank you very much for your help. Just a little thing. I've done as
> you say:
>
> CREATE TABLE rain_series_dated AS SELECT (year * interval '1 year' + month *
> interval '1 month' + day * interval '1 day') AS
> fecha,est7237,est7238,est7239,est7250 FROM rain_series ORDER by fecha;
It would probably be better to use a view instead of copying the data
to another table. That way you don't need to worry about the data
getting out of sync.
> And I've tried to use this result to be compared with my other table in which
> "fecha" is "date" type. The result is that the query halts with no result; I
> guess that it is because it tries to compare different data types.
It wouldn't be because of trying to compare a date and an interval.
You would get an error message instead.
> Is it possible to cast the "interval" obtained type into a "date" one in the
> creation of the mentioned table? (I've looked it in the documentation, but I
> can't find the answer)
Not really. You could add the interval values to a base date, but that may
or may not make sense depending on your application.