[Firebird-devel] Odp: row_number window function with over()

Hi, Interesting :) then i see FB work in the same way as PGSQL if this is good and SQL conformant then all is ok. Thanks Dmitry i have not PGSQL installed anywhere only, IB, FB, MSSQL, ORACLE and Ingress. Only two of them have window function implemented Regards, Karol Bieniaszewski - Rep

Re: [Firebird-devel] Type BOOLEAN in FB3

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 >> wh

Re: [Firebird-devel] Type BOOLEAN in FB3

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 >>>

[Firebird-devel] [FB-Tracker] Created: (CORE-4177) Problem with some boolean expressions not being allowed

Problem with some boolean expressions not being allowed --- Key: CORE-4177 URL: http://tracker.firebirdsql.org/browse/CORE-4177 Project: Firebird Core Issue Type: Bug Components:

[Firebird-devel] [FB-Tracker] Created: (CORE-4178) New API should return proper metadata properties, not the historical artifacts

New API should return proper metadata properties, not the historical artifacts -- Key: CORE-4178 URL: http://tracker.firebirdsql.org/browse/CORE-4178 Project: Firebird Core

Re: [Firebird-devel] Type BOOLEAN in FB3

Adriano dos Santos Fernandes писал(а) в своём письме 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 WHERE true + true true + true = ? true + false = ? false + fal