dbadmin=> SELECT * FROM test;
c1 | c2
----+-------
1 | A|B|C
2 | D|E|F
(2 rows)
dbadmin=> SELECT c1, words FROM (SELECT c1, StringTokenizerDelim(c2, '|') OVER (PARTITION BY c1 ORDER BY c1)
dbadmin(> FROM test) foo
dbadmin-> ORDER BY 1, 2;
c1 | words
----+-------
1 | A
1 | B
1 | C
2 | D
2 | E
2 | F
(6 rows)About the Author
Soniya Shah
Information Developer
Currently, a first year law student with a background in science and technology. Experienced technical writer, with specializations in software documentation, big data, blog development, and website development. I build user-centered content to communicate complex and technical information more easily.
I used to work for Vertica full time for about 3 years. I still work at Vertica part time while going to law school.
Update: Soniya is now doing her law internship, and no longer working at Vertica. Good luck, Soniya!
