interval and timestamp change?

From: "postgresql" <pgsql(at)symcom(dot)com>
To: "PgSQL-SQL" <pgsql-sql(at)postgresql(dot)org>
Subject: interval and timestamp change?
Date: 2002-01-27 00:03:06
Message-ID: 200201262346.g0QNkXl96573@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message chester c young 2002-01-27 00:18:45 update syntax
Previous Message Bruce Momjian 2002-01-26 23:11:14 Re: LIMIT Optimization