cs/cd operators are also useful when working with jsonb (not just arrays) so with the current handling one can only run queries like these because of the auto wrapping:
SELECT '{1, 2, 3}'::integer[] @> '{2}';
if this is removed (and the lib user is required to format the value), they can now run queries like:
cs/cd operators are also useful when working with jsonb (not just arrays) so with the current handling one can only run queries like these because of the auto wrapping: SELECT '{1, 2, 3}'::integer[] @> '{2}';
if this is removed (and the lib user is required to format the value), they can now run queries like:
select '[1,2,3]'::jsonb @> '2'; select '[1,2,3]'::jsonb @> '[2,3]'; select '{1, 2, 3}'::integer[] @> '{2,3}';
because they are now in control of the value formatting.