Having trouble with Interval computation - Mailing list pgsql-general

From Jim Ballard
Subject Having trouble with Interval computation
Date
Msg-id 000801c10e0e$23951b70$8300a8c0@planet
Whole thread Raw
Responses Re: Having trouble with Interval computation
List 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
 

pgsql-general by date:

Previous
From: "Thalis A. Kalfigopoulos"
Date:
Subject: Re: SQL for CREATE RULE
Next
From: "Thalis A. Kalfigopoulos"
Date:
Subject: Re: PASSWORD() function for postgresql?