Lane's Site

2024-09-21-chatgpt does does a good job at helping with pos

1 min read

chatgpt does does a good job at helping with postgres SQL JSONB and sub-arrays:

SELECT *
FROM your_table
WHERE meta -> 'Tags' @> '"cool-tag"'
  AND (meta ->> 'Situps')::int = 0
  AND (meta ->> 'Pushups')::int = 0;

(Notice the double quotes inside a single quote)