Skip to content

Instantly share code, notes, and snippets.

@jrjames83

jrjames83/ian.txt

Created June 26, 2017 14:44
Show Gist options
  • Save jrjames83/2e334aede7a17a6013d2010f4a87dc20 to your computer and use it in GitHub Desktop.
Save jrjames83/2e334aede7a17a6013d2010f4a87dc20 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
ian.txt
jeff=# SELECT * FROM sample_data sd;
string_data
----------------
en-src-m2m sim
en-src-m2m dog
en-src-m2m cat
(3 rows)
jeff=# select sd.string_data, split_part(sd.string_data, ' ', 1),split_part(sd.string_data, ' ', 2) FROM sample_data sd;
string_data | split_part | split_part
----------------+------------+------------
en-src-m2m sim | en-src-m2m | sim
en-src-m2m dog | en-src-m2m | dog
en-src-m2m cat | en-src-m2m | cat
(3 rows)
jeff=#
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment