Re: [HACKERS] jsonb problematic operators - Mailing list pgsql-hackers

From Greg Stark
Subject Re: [HACKERS] jsonb problematic operators
Date
Msg-id CAM-w4HMkHUs9Y+i25kGLLKJp30ACaPE1X8fDTpaRMOW2kBsN4w@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] jsonb problematic operators  (Craig Ringer <craig@2ndquadrant.com>)
Responses Re: [HACKERS] jsonb problematic operators  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-hackers
On 12 December 2016 at 04:59, Craig Ringer <craig@2ndquadrant.com> wrote:
> I didn't realise Pg's use of ? was that old, so thanks. That makes
> offering alternatives much less appealing.

One option might be for Postgres to define duplicate operator names
using ¿ or something else. I think ¿ is a good choice because it's a
common punctuation mark in spanish so it's probably not hard to find
on a lot of keyboards or hard to find instructions on how to type one.

There is always a risk in allowing redundant syntaxes though. For
example people running grep to find all uses of an operator will miss
the alternate spelling. There may even be security implications for
that though to be honest that seems unlikely in this case.

--
greg



pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [HACKERS] pgcrypto compilation error due to stack-allocated EVP_CIPHER_CTX
Next
From: Andrew Dunstan
Date:
Subject: Re: [HACKERS] jacana hung after failing to acquire random number