Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- WITH temp (name, aliases) AS (VALUES (1, '[{"value":"test"}, {"value":"wrong"}]'::jsonb), (2, '[{"value":"another"}, {"value":"wrong"}]'::jsonb), (3, '[{"value":"another"}, {"value":"test"}]'::jsonb))
- SELECT * FROM temp
- WHERE EXISTS (
- SELECT 1 FROM jsonb_array_elements(aliases) AS j(DATA) WHERE (DATA #>> '{value}') ilike '%es%');
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement