[development] Will this work in Postgres?

[Ivan Sergio Borgonovo]

On Mon, 24 Aug 2009 13:19:33 -0400
"Nancy Wichmann" <nan_wich at bellsouth.net> wrote:

> >From looking at the PG docs, I see that "DATE( FROM_UNIXTIME(
> r.timestamp ) ) AS 'date'" probably needs to be changed to
> "CAST(r.timestamp AS date) AS 'date'" and I can do that in my
> code. The funny thing is that the MySql docs mention doing the
> same, but it returns a NULL.

postgresql has to_timestamp(double precision) from 8.1 but it
doesn't seem it is supported by mysql.
I think it is better you convert the date on the php side.

pg uses " to quote identifiers and alias.

Other than that I've no site that really use revisions to really
test your sql.

Other than that it ran without errors.

-- 
Ivan Sergio Borgonovo
http://www.webthatworks.it