Postgres Pro
Downloads
Home   >   mailing lists

Re: Add hint for function named "is" - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Add hint for function named "is"
Date
Msg-id 4124.1471049661@sss.pgh.pa.us
Whole thread Raw
In response to Re: Add hint for function named "is"  (Greg Stark <stark@mit.edu>)
List pgsql-hackers
Tree view 
Greg Stark <stark@mit.edu> writes:
> On Fri, Aug 12, 2016 at 7:40 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> pointing out that "SELECT 42 ISNULL" is now ambiguous.  Since ISNULL
>> is nonstandard, maybe dropping support for it would be feasible.

> Isn't ISNULL one of the lexical tricks we used to effectively give
> bison two token lookahead?

No, it's a SQL-exposed feature, though I think it's just there for
compatibility with some random other DBMS.  See also NOTNULL.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: Btree Index on PostgreSQL and Wiredtiger (MongoDB3.2)
Next
From: Thomas Munro
Date:
Subject: Re: Server crash due to SIGBUS(Bus Error) when trying to access the memory created using dsm_create().