Hi,
I've got a table to import from csv that has an array-column like:
import ( id, array_col, ... )
Those arrays look like ( 42, ";4941;4931;4932", ... )
They can have 0 or any number of elements separated by ;
So I'd need a result like this:
42, 4941
42, 4931
42, 4932
How would I get this?
You can try
select id, unnest(array_col) from table
Venky Kandaswamy
Principal Engineer, Adchemy Inc.
925-200-7124
From: pgsql-sql-ow...@postgresql.org [pgsql-sql-ow...@postgresql.org] on behalf
of Andrea
Thanks for the pointer.
It got me half way.
This is the solution:
select distinct id, unnest ( string_to_array ( trim ( array_column, ';'
), ';' ) ) from import;
Am 18.03.2013 20:24, schrieb Venky Kandaswamy:
You can try
select id, unnest(array_col) from table
__
