am Fri, dem 23.02.2007, um 19:25:35 +0100 mailte Stefan Becker folgendes: > Now: Is there a syntax that allows for the following..... > > create table XX (id int); > insert into XX (select xx from "1 to 1000" of integers)
Perhaps you are searching for generate_series(): test=*# select generate_series(1,10); generate_series ----------------- 1 2 3 4 5 6 7 8 9 10 (10 rows) Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate