[HACKERS] jsonb problematic operators
От | Jordan Gigov |
---|---|
Тема | [HACKERS] jsonb problematic operators |
Дата | |
Msg-id | CA+nBocB+DPnZRDB7JNvoTGuireM3BqJyz4sLqUCYT6tuM6SWfA@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: [HACKERS] jsonb problematic operators
Re: [HACKERS] jsonb problematic operators Re: [HACKERS] jsonb problematic operators Re: [HACKERS] jsonb problematic operators |
Список | 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 по дате отправления: