Re: Problems with question marks in operators (JDBC, ECPG, ...) - Mailing list pgsql-hackers

From Bruno Harbulot
Subject Re: Problems with question marks in operators (JDBC, ECPG, ...)
Date
Msg-id CANPVNBaCQTV9_c=qw9wGEMkTD6PNEnsHo8zL0O0__ZJM3kb2HA@mail.gmail.com
Whole thread Raw
In response to Re: Problems with question marks in operators (JDBC, ECPG, ...)  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-hackers


On Wed, May 20, 2015 at 7:04 PM, Jeff Janes <jeff.janes@gmail.com> wrote:

What if something like this was made to work?

 select '{"3":5}'::jsonb operator("pg_catalog"."?") '3';

(Where the double quotes around the ? would be tolerated, which they currently are not)

Is there a reason it can't be made to work?
 

I'm not sure whether that could be made to work, but wouldn't that defeat the point of using operators, i.e. something rather short, as opposed to functions? (That's also partly one of the arguments against too much escaping: over-complicating what's intended to be a relatively simple notation, as the Hibernate example I mentioned earlier showed: "SELECT ..... \\?\\? ....".)

Best wishes,

Bruno.

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Disabling trust/ident authentication configure option
Next
From: Tom Lane
Date:
Subject: Re: Problems with question marks in operators (JDBC, ECPG, ...)