Message-ID: <46443F5F.7060603@wp.pl>
Date: Fri, 11 May 2007 12:03:11 +0200
From: Ireneusz Pluta <ipluta@wp.pl>
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
To: marchesini@unipg.it
CC: pgsql-sql@postgresql.org
Subject: Re: insert a sequence
References: <1178808572.4294.15.camel@ivangeo>
In-Reply-To: <1178808572.4294.15.camel@ivangeo>
Content-Type: text/plain; charset=ISO-8859-2; format=flowed
Content-Transfer-Encoding: 8bit

ivan marchesini napisał(a):
> Dear postgres Users,
> I have a simple question I think.
> I have a table that contains some columns
> one of these columns (the columns ID) contains distinct integer
> values ...
> I need to insert into this table some other records but I only need that
> values were inserted into the ID column and that they were
> progressive... (a sequence starting from 100 and ending to 300, step=1) 
> the other columns must remains null....
> can I do this with a sequence and then an "insert into"?
>
> many thanks 
>
>
>
>
>   
INSERT INTO your_table (id) SELECT generate_series(100, 300, 1);

-> http://www.postgresql.org/docs/8.2/interactive/functions-srf.html