> extract(DOW FROM TIMESTAMP TIMESTAMP(a.startdate)) AS "dow",
> ERROR: parser: parse error at or near "TIMESTAMP"
Try one of these:
extract(dow from cast(a.startdate as timestamp)) as "dow"
extract(dow from a.startdate) as "dow"
extract(dow from a.startdate::timestamp) as "dow"
I remember I had problems when migrating to Postgres 7.2. I don't
remember why, but I had to convert all "timestamp" to "timestamp without
time zone". Probably this was because of ZEOS-direct-access components
for C++ Builder.
Regards,
Tomasz Myrta