output array elements in rows - Mailing list pgsql-general

From Rainer.Zaiss@bondy.ird.fr
Subject output array elements in rows
Date
Msg-id 1209842384.481cbad06fb9f@webmail.bondy.ird.fr
Whole thread Raw
List pgsql-general
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


pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Interesting comments about fsync on Linux
Next
From: "David Anderson"
Date:
Subject: Problems in queries