From: | Andreas <maps(dot)on(at)gmx(dot)net> |
---|---|
To: | Venky Kandaswamy <venky(at)adchemy(dot)com> |
Cc: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: How to split an array-column? |
Date: | 2013-03-18 20:43:33 |
Message-ID: | 51477C75.8010108@gmx.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
>
> ....
> ________________________________________
>
> Venky Kandaswamy
>
> Principal Engineer, Adchemy Inc.
>
> 925-200-7124
>
> ________________________________________
> From: pgsql-sql-owner(at)postgresql(dot)org [pgsql-sql-owner(at)postgresql(dot)org] on behalf of Andreas [maps(dot)on(at)gmx(dot)net]
> Sent: Monday, March 18, 2013 12:13 PM
> To: pgsql-sql(at)postgresql(dot)org
> Subject: [SQL] How to split an array-column?
>
> 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?
>
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jose Antonio Quintana/UPC | 2013-03-21 11:43:01 | Reading from file without superuser privilege |
Previous Message | Venky Kandaswamy | 2013-03-18 19:24:55 | Re: How to split an array-column? |