Re: [Firebird-devel] Type BOOLEAN in FB3

2013-08-12 Thread Adriano dos Santos Fernandes
On 12/08/2013 00:33, Simonov Denis wrote: Adriano dos Santos Fernandes adrian...@gmail.com писал(а) в своём письме Mon, 12 Aug 2013 05:28:25 +0400: Please ignore this. What PostgreSQL seems to accept (at parser level) and is not standard is: - WHERE (1 = 1) + (2 = 2) It's analog

Re: [Firebird-devel] Type BOOLEAN in FB3

2013-08-11 Thread Adriano dos Santos Fernandes
On 05-08-2013 05:17, Dmitry Yemanov wrote: 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.

Re: [Firebird-devel] Type BOOLEAN in FB3

2013-08-11 Thread Adriano dos Santos Fernandes
Please ignore this. What PostgreSQL seems to accept (at parser level) and is not standard is: - WHERE (1 = 1) + (2 = 2) Adriano On 11-08-2013 22:17, Adriano dos Santos Fernandes wrote: On 05-08-2013 05:17, Dmitry Yemanov wrote: 04.08.2013 16:47, Simonov Denis wrote: select 1 from

Re: [Firebird-devel] Type BOOLEAN in FB3

2013-08-06 Thread Adriano dos Santos Fernandes
On 05/08/2013 05:17, Dmitry Yemanov wrote: 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.

Re: [Firebird-devel] Type BOOLEAN in FB3

2013-08-05 Thread Dmitry Yemanov
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.

[Firebird-devel] Type BOOLEAN in FB3

2013-08-04 Thread Simonov Denis
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. And shall be or