insert a sequence

From: ivan marchesini <marchesini(at)unipg(dot)it>
To: pgsql-sql(at)postgresql(dot)org
Subject: insert a sequence
Date: 2007-05-10 14:49:32
Message-ID: 1178808572.4294.15.camel@ivangeo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

--
Ti prego di cercare di non inviarmi files .doc, .xls, .ppt, .dwg.
Preferisco formati liberi.
Please try to avoid to send me .doc, .xls, .ppt, .dwg files.
I prefer free formats.
http://it.wikipedia.org/wiki/Formato_aperto
http://en.wikipedia.org/wiki/Open_format

Ivan Marchesini
Department of Civil and Environmental Engineering
University of Perugia
Via G. Duranti 93/a
06125
Perugia (Italy)
e-mail: marchesini(at)unipg(dot)it
ivan(dot)marchesini(at)gmail(dot)com
tel: +39(0)755853760
fax (university): +39(0)755853756
fax (home): +39(0)5782830887
jabber: geoivan73(at)jabber(dot)org

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message chester c young 2007-05-10 18:34:22 Re: Count rows by day interval
Previous Message Louis-David Mitterrand 2007-05-10 08:05:09 Re: query to select a linked list