javier garcia - CEBAS writes:
> 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?
year * interval '1 year' + month * interval '1 month' + day * interval '1 day'
This results in a timestamp value that you can compare to or assign to a
date value.
--
Peter Eisentraut [EMAIL PROTECTED]
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
