[HACKERS] jsonb problematic operators

Поиск
Список
Период
Сортировка
От Jordan Gigov
Тема [HACKERS] jsonb problematic operators
Дата
Msg-id CA+nBocB+DPnZRDB7JNvoTGuireM3BqJyz4sLqUCYT6tuM6SWfA@mail.gmail.com
обсуждение исходный текст
Ответы Re: [HACKERS] jsonb problematic operators  (Geoff Winkless <pgsqladmin@geoff.dj>)
Re: [HACKERS] jsonb problematic operators  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: [HACKERS] jsonb problematic operators  (Robert Haas <robertmhaas@gmail.com>)
Re: [HACKERS] jsonb problematic operators  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-hackers
There is this problem with the jsonb operators "? text" "?| text[]"
and "?& text[]" that the question mark is typically used for prepared
statement parameters in the most used abstraction APIs in Java and
PHP.

This really needs an alternative. Something like "HAS text", "HAS
ANY(text[])" and "HAS ALL(text[])" same as regular array usage. It
probably should be another word that has less chance of becoming a
conflict with another operator in future SQL specifications, but
that's for you to decide.

It's not a good idea to expect everyone else to make for workarounds
for problems you choose to create.



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: [HACKERS] Password identifiers, protocol aging and SCRAM protocol
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: [HACKERS] `array_position...()` causes SIGSEGV