Skip to content

Instantly share code, notes, and snippets.

@kovid-rathee

kovid-rathee/unnest_array_in_postgresql.sql

Created February 24, 2019 09:34
Show Gist options
  • Save kovid-rathee/e46d1d0ba236c34d39cfb030e6f0a1d7 to your computer and use it in GitHub Desktop.
Save kovid-rathee/e46d1d0ba236c34d39cfb030e6f0a1d7 to your computer and use it in GitHub Desktop.
Download ZIP
Unnest array in PostgreSQL
Raw
unnest_array_in_postgresql.sql
select name,
unnest(schedule),
unnest(pay_by_quarter)
from sal_emp;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment