Re: [GENERAL] unnest and string_to_array on two columns

2011-10-25 Thread David Johnston
-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Michael Graham Sent: Tuesday, October 25, 2011 4:36 AM To: pgsql-general@postgresql.org Subject: [GENERAL] unnest and string_to_array on two columns Hi all, I'm tryi

[GENERAL] unnest and string_to_array on two columns

2011-10-25 Thread Michael Graham
Hi all, I'm trying to migrate an old (and sucky) schema to a new one and I'm having some difficulties coming up with a sane select. I have basically id, a, and b where a and b contain a list of flags like id | a| b | 1 | abc | abcdef | and what to convert this to