Are there any changes to INTERVAL in 7.2

From: "Mr OCP" <mr_ocp(at)hotmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Are there any changes to INTERVAL in 7.2
Date: 2002-11-12 01:35:45
Message-ID: F6gEacF1s5IOiV3Xpfb000037a3@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi

The following query involving INTERVAL works very well in 7.1 but does not
work under 7.2

SELECT order_id FROM order
WHERE order_date + INTERVAL
(term ||'year') < current_timestamp;

Are there any changes to this functionality in 7.2 from 7.1.

Please comment
Thanks
Khat

_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Stephan Szabo 2002-11-12 01:55:58 Re: Are there any changes to INTERVAL in 7.2
Previous Message Gary DeSorbo 2002-11-11 17:49:48 Monitor Tools