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

From Geoff Winkless
Subject Re: [HACKERS] jsonb problematic operators
Date
Msg-id CAEzk6fe0=xu+kh0j8uMJ-NwUd=+952tLe-HvCPHCsJsMGnLa+Q@mail.gmail.com
Whole thread Raw
In response to [HACKERS] jsonb problematic operators  (Jordan Gigov <coladict@gmail.com>)
Responses Re: [HACKERS] jsonb problematic operators
List pgsql-hackers
On 9 Dec 2016 17:54, "Andres Freund" <andres@anarazel.de> wrote:
On 2016-12-09 12:17:32 -0500, Robert Haas 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.

Well, except that only operators support indexing :(

Really? Seems like an odd design decision.

The only other simple suggestion then would be to use PDO named parameters instead of positional ones. Much nicer syntax anyway, IMO.

Geoff


pgsql-hackers by date:

Previous
From: Andrew Borodin
Date:
Subject: Re: [HACKERS] background sessions
Next
From: Kevin Grittner
Date:
Subject: Re: [HACKERS] snapbuild woes