Having trouble with Interval computation

Jim Ballard <jballard@netezza.com>

From: "Jim Ballard" <jballard@netezza.com>
To: <pgsql-general@postgresql.org>
Date: 2001-07-16T15:44:03Z
Lists: pgsql-general
I'd like to get the difference between two timestamp columns expressed as an interval with units "year to month."  I believe the standard way to express this is as:

   (timestamp1 - timestamp2) year to month

But this gives me a syntax error at "year".  I also can't find a way to cast this to the desired interval units.

What is the proper way to express this in Postgres?  Will the standard form be supported at some point?

Thanks very much,

Jim Ballard
jballard@netezza.com