Postgres Pro
Downloads
Home   >   mailing lists

BUG #13892: SELECT FALSE = FALSE = TRUE; error - Mailing list pgsql-bugs

From fotonszekta@gmail.com
Subject BUG #13892: SELECT FALSE = FALSE = TRUE; error
Date
Msg-id 20160127025427.2541.77585@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #13892: SELECT FALSE = FALSE = TRUE; error
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      13892
Logged by:          Gábor Szabó
Email address:      fotonszekta@gmail.com
PostgreSQL version: 9.5.0
Operating system:   Windows 10 x64
Description:

I read a post on "SELECT FALSE = FALSE = TRUE;"
(http://databaseblog.myname.nl/2016/01/when-simple-sql-can-be-complex.html)

I tried on 9.5, and it's throws an error:
ERROR: syntax error at or near "="
LINE 1: SELECT FALSE = FALSE = TRUE;
                             ^
(the error is at the second '=')

It's maybe related to "Adjust operator precedence to match the SQL
standard"

9.1 and 9.4 returns true as excepted

pgsql-bugs by date:

Previous
From: Andres Freund
Date:
Subject: Re: << unrecognized configuration parameter "pg_stat_statements.track" >>
Next
From: Vladimir Kunschikov
Date:
Subject: Re: BUG #13888: pg_dump write error