Just to inform you to check your code:

select *  from MyTable where MyDate < (current_date  - interval 30 day)

doesn't work any more in 2.03.

interval '30' is correct, as it was before, but the old versions
accepted an integer value here as well.

Uli

Uli,

<< Just to inform you to check your code:

select *  from MyTable where MyDate < (current_date  - interval 30 day)

doesn't work any more in 2.03.

interval '30' is correct, as it was before, but the old versions accepted
an integer value here as well. >>

Here's the incident report:

http://www.elevatesoft.com/incident?action=viewaddr&category=edb&release=2.03&type=f&incident=3066

I got bit with this fix 3 times in the test framework.

--
Tim Young
Elevate Software
www.elevatesoft.com