Dear list, I'm looking for a function to output the elements of my array column in rows ? Let's say I have following table:
id = integer nam= array char varying id nam 1 {"nam1","nam2","nam3"} 2 {"n1","n2"} I think there should be available a function to expand the elements of an array of caractères into a set of rows ? id nam 1 nam1 1 nam2 1 nam3 2 n1 2 n2 THANK YOU VERY MUCH FOR YOUR HELP -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general