interval and timestamp change? - Mailing list pgsql-sql

From postgresql
Subject interval and timestamp change?
Date
Msg-id 200201262346.g0QNkXl96573@postgresql.org
Whole thread Raw
Responses Re: interval and timestamp change?
List pgsql-sql
this works on  postgresql 7.1.3.

SELECT interval(('1/30/02  12:30 pm'::timestamp) - 'now');

However, it is failing on the current beta. I have to change it to:

SELECT ('1/30/02  12:30 pm'::timestamp) - 'now';

Is this change to make PG more ANSI compliant? Was this 
documented? It  took me a bit of hacking to find the correct syntax in 
7.2.

Ted




pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: LIMIT Optimization
Next
From: chester c young
Date:
Subject: update syntax