04.08.2013 16:47, Simonov Denis wrote:
>
> select 1
>   from rdb$database
> where true is true
>
>
> Work is correct
>
> select 1
>   from rdb$database
> where (1=1) and true
>
>
> Work is correct
>
> select 1
>   from rdb$database
> where (1=1) is true
>
>
> Invalid token.
> Dynamic SQL Error.
> SQL error code = -104.
> Token unknown - line 3, column 13.
> is.

Accordingly to the SQL specification, it should work. Adriano, is it 
prohibited intentionally?


Dmitry


------------------------------------------------------------------------------
Get your SQL database under version control now!
Version control is standard for application code, but databases havent 
caught up. So what steps can you take to put your SQL databases under 
version control? Why should you start doing it? Read more to find out.
http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to