Skip to content

Instantly share code, notes, and snippets.

@dev-armando

dev-armando/unnest_postgres.sql

Created January 7, 2022 20:47
Show Gist options
  • Save dev-armando/9eb08085c64aa4f024ea2b584f6da6f3 to your computer and use it in GitHub Desktop.
Save dev-armando/9eb08085c64aa4f024ea2b584f6da6f3 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
unnest_postgres.sql
select
CASE
WHEN '432432' in (select unnest(string_to_array( '432432,545345' , ','))) THEN 'yes'
else 'nada'
END
;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment