On Mon, 11 Nov 2002, Mr OCP wrote: > 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.
>From the release notes: * The timestamp(), time(), and interval() functions are no longer available. Instead of timestamp(), use timestamp 'string' or CAST. Try CAST(term || 'year' as INTERVAL) ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly