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 peter_e(at)gmx(dot)net