Converting each item in array to a query result row
От
Postgres User
Тема
Converting each item in array to a query result row
Дата
Msg-id
b88c3460905290021o6870bb46tec88ced0c40643d9@mail.gmail.com
Список
Дерево обсуждения
Converting each item in array to a query result row Postgres User <postgres.developer@gmail.com>
Re: Converting each item in array to a query result row Gevik Babakhani <pgdev@xs4all.nl>
Hi,
I'd writing a query against a function (pg_proc) that contains 2
fields of an array type. Ideally, I'd like to select 1 row from the
table, but return a query row for each item in the array.
For example, if one row contains the array {"a", "b", "c"}
I'd like the query to return 3 rows, one for each of these elements.
Any idea if this is possible?
Thanks.
В списке pgsql-general по дате отправления
От: Scott Marlowe
Дата:
От: artacus@comcast.net
Дата: