Skip to content

Instantly share code, notes, and snippets.

@ichux

ichux/postgres-array.sql

Created September 17, 2018 05:35
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ichux/17b64a4fd8a0e7fdeb3d967209624d9b to your computer and use it in GitHub Desktop.
Save ichux/17b64a4fd8a0e7fdeb3d967209624d9b to your computer and use it in GitHub Desktop.
Download ZIP
demo arrays in postgres
Raw
postgres-array.sql
SELECT
( n % 2 ) :: TEXT,
ARRAY_AGG ( n )
FROM
generate_series ( 1, 10 ) n
GROUP BY
( n % 2 ) :: TEXT;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment