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
