Re: insert into table from list or array ?

  Am 18.10.2010 20:14, schrieb Pavel Stehule:
> 2010/10/18 Andreas:
>> is it possible to insert into a table from list or an array ?
> yes, it's possible
>
> INSERT INTO tmptab
>     SELECT v
>       FROM unnest(string_to_array('1,2,4,2,1',',')) g(v)
>

Thanks Pavel,
though I'm just not yet 100% aware how it works but it works.   :)