HOWTO: select * from array_type

From: alefajnie <devphyl(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: HOWTO: select * from array_type
Date: 2008-09-11 14:42:04
Message-ID: b8fc7f71-0dae-492d-aaff-5cc14d76dd77@m36g2000hse.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 ?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2008-09-11 14:56:56 Re: "Healing" a table after massive updates
Previous Message Alvaro Herrera 2008-09-11 14:41:00 Re: "Healing" a table after massive updates