Re: [Firebird-devel] second condition after a between condition is not working

2013-09-18 Thread Adriano dos Santos Fernandes
On 17/09/2013 16:44, Evelyne Girard wrote: > > Hi, > > > > With Firebird 3.0 a secondary condition after a between condition is > not accepted (due to new Boolean type presumably) whereas it was in > Firebird 2.5 > > I do not know if it is « as designed » but I did not see any warning > about thi

Re: [Firebird-devel] second condition after a between condition is not working

2013-09-18 Thread Evelyne Girard
> Although I can't speak to the development side of things, I learned my > lesson a long time ago about separating conditions with (parenthesis) just > for clarity. Have you tried to see if it works like that? Woody: Yes it is working with parenthesis, the problem is not that I don't know how t

Re: [Firebird-devel] second condition after a between condition is not working

2013-09-18 Thread Mark Rotteveel
On 17-9-2013 21:44, Evelyne Girard wrote: > Hi, > > With Firebird 3.0 a secondary condition after a between condition is not > accepted (due to new Boolean type presumably) whereas it was in Firebird 2.5 > > I do not know if it is « as designed » but I did not see any warning > about this in the re

[Firebird-devel] second condition after a between condition is not working

2013-09-17 Thread Evelyne Girard
Hi, With Firebird 3.0 a secondary condition after a between condition is not accepted (due to new Boolean type presumably) whereas it was in Firebird 2.5 I do not know if it is < as designed > but I did not see any warning about this in the release notes. select * from rdb$database where rdb$re