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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
