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

From Tom Lane
Subject Re: Problems with question marks in operators (JDBC, ECPG, ...)
Date
Msg-id 23889.1432145598@sss.pgh.pa.us
Whole thread Raw
In response to Re: Problems with question marks in operators (JDBC, ECPG, ...)  (Jeff Janes <jeff.janes@gmail.com>)
Responses Re: Problems with question marks in operators (JDBC, ECPG, ...)  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-hackers
Jeff Janes <jeff.janes@gmail.com> writes:
> 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?

It could be made to work, I'm sure, but I fail to see why any user
would prefer to write that over ?? or \? or {?} or pretty much any
of the other notations that've been suggested.  It's ten times as
many keystrokes ...
        regards, tom lane



pgsql-hackers by date:

Previous
From: Bruno Harbulot
Date:
Subject: Re: Problems with question marks in operators (JDBC, ECPG, ...)
Next
From: Peter Geoghegan
Date:
Subject: Re: INSERT ... ON CONFLICT UPDATE/IGNORE 4.0