Re: [SQL] insert into table from list or array ?

[Andreas]

 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.   :)

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql