DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:from:date:message-id:subject:to
	:cc:content-type:content-transfer-encoding;
	b=TJPDgWPGGwOFmCpJec3hW4nK6XVjI9ib05AN6/OfYTgvM77HaTtO5i924mehJEKjjs
	x3zJ6Qp1AaoO26/Mcxs7fmk+Osc53xbcwnu5EfpLfwGckxXJpdxoZ/JLP+zFPbv/CNmt
	NlNZTqWx07ulybWdbatLyJ8aXXoDWwuVmG+ZQ=
MIME-Version: 1.0
In-Reply-To: <4CBC8B3B.7060708@gmx.net>
References: <4CBC8B3B.7060708@gmx.net>
From: Pavel Stehule <pavel.stehule@gmail.com>
Date: Mon, 18 Oct 2010 20:14:28 +0200
Message-ID: <AANLkTimxaYzBmm9PyLXgf9okbLmM0eYTMQmgU1kpTZNr@mail.gmail.com>
Subject: Re: insert into table from list or array ?
To: Andreas <maps.on@gmx.net>
Cc: pgsql-sql@postgresql.org
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Hello

2010/10/18 Andreas <maps.on@gmx.net>:
> =C2=A0Hi,
>
> 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)

Regards

Pavel Stehule

> Suppose there is a set of numbers that might be IDs of tables within the =
DB.
> To work with them I'd need a temporary table that just holds a single col=
umn
> with those numbers.
> Something like
>
> create temporary table tmptable as select id from
> ( 2, 3, 5, 7, 11, 13, 17, 19, 23, 31,
> =C2=A037, ... );
>
> would be great.
>
> I get those numbers as textfile with 10 numbers per line and devided by
> comma+space as in the sample above, though the comma+space is negotiable =
if
> this were an issue.
>
> :)
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>