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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
