Vol. I · A Postgres HandbookTwelve chapters · · 756 queries

The Query & the Schema

A reading-room reference for writing PostgreSQL by hand — selects to window functions, with the schema in plain view.

IntermediateBasic SELECT

Querying Array columns

SQL

SELECT title 
FROM blog_posts 
WHERE 'sql' = ANY(tags);

Tested against PostgreSQL 16

Note

“ANY() checks if a value exists inside an array column. Fast and natively supported.