HOWTO: select * from array_type - Mailing list pgsql-general

From alefajnie
Subject HOWTO: select * from array_type
Date
Msg-id b8fc7f71-0dae-492d-aaff-5cc14d76dd77@m36g2000hse.googlegroups.com
Whole thread Raw
Responses Re: HOWTO: select * from array_type  ("Pavel Stehule" <pavel.stehule@gmail.com>)
List pgsql-general
hey

I have : (A)
select (string_to_array(mycolumn, ' ')) from mytable  where id = sth;

and here receive:
{'one', 'two', 'three'}
1 row

but I want 3 rows with data:
'one'
'two'
'three'


how make second select of above (A) ?

btw: is any subtrace on psql arrays ?

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Default procedural language
Next
From: "Brent Wood"
Date:
Subject: Help with a foreign key with non-unique reference?