On 9 December 2016 at 11:50, Jordan Gigov <colad...@gmail.com> wrote: > 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.
You mean something like the jsonb_ functions ? \df jsonb* > It's not a good idea to expect everyone else to make for workarounds > for problems you choose to create. I'd say it's not a good idea to come asking questions of a mailing list with an attitude like that, but hey, it's nearly Holidays. Geoff -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
