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

From Tom Lane
Subject Re: [HACKERS] jsonb problematic operators
Date
Msg-id 20158.1481653511@sss.pgh.pa.us
Whole thread Raw
In response to [HACKERS] jsonb problematic operators  (Jordan Gigov <coladict@gmail.com>)
List pgsql-hackers
Nico Williams <nico@cryptonector.com> writes:
> On Tue, Dec 13, 2016 at 10:26:24AM +0900, Michael Paquier wrote:
>> On Mon, Dec 12, 2016 at 10:22 PM, Greg Stark <stark@mit.edu> wrote:
>>> One option might be for Postgres to define duplicate operator names
>>> using ¿ or something else.

>> Are you sure that using a non-ASCII character is a good idea for an
>> in-core operator? I would think no.

> Eventually language designers will cross that Rubicon in mainstream
> languages.  And why not?

Because it will create all sorts of character-set-conversion hazards.

In the current design of Postgres it flat out would not work, because
template0 has to be encoding-agnostic.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [HACKERS] Declarative partitioning - another take
Next
From: ronan.dunklau@dalibo.com
Date:
Subject: Re: [HACKERS] New design for FK-based join selectivity estimation