Search Postgresql Archives

HOWTO: select * from array_type

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 ?


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux