Re: Problems with question marks in operators (JDBC, ECPG, ...)

Поиск
Список
Период
Сортировка
От Bruno Harbulot
Тема Re: Problems with question marks in operators (JDBC, ECPG, ...)
Дата
Msg-id CANPVNBaCQTV9_c=qw9wGEMkTD6PNEnsHo8zL0O0__ZJM3kb2HA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Problems with question marks in operators (JDBC, ECPG, ...)  (Jeff Janes <jeff.janes@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Disabling trust/ident authentication configure option
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Problems with question marks in operators (JDBC, ECPG, ...)