Re: 7.2 time format funtion issue

> 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