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

From David G. Johnston
Subject Re: [HACKERS] jsonb problematic operators
Date
Msg-id CAKFQuwaPLsp6=Y7Q1JFPF=FqF1tXO6KRNrrRzLb-3rLyuAiE5A@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] jsonb problematic operators  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On Fri, Dec 9, 2016 at 10:17 AM, Robert Haas <robertmhaas@gmail.com> wrote:

As Geoff says, you don't have to use the operators; you could use the
equivalent functions instead.  Every operator just gets turned into a
function call internally, so this is always possible.

In most cases - the decision to tie indexing to operators makes this imperfect.  Whether there is an actual problem with these operators I am unsure.

David J.

pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: [HACKERS] proposal: psql statements \gstore \gstore_binary (instead COPY RAW)
Next
From: Andres Freund
Date:
Subject: Re: [HACKERS] jsonb problematic operators