Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id D72FD9FC1FA for ; Fri, 23 Feb 2007 15:32:02 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 68616-06 for ; Fri, 23 Feb 2007 15:31:54 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.174]) by postgresql.org (Postfix) with ESMTP id 629059FB528 for ; Fri, 23 Feb 2007 15:31:56 -0400 (AST) Received: from [194.25.154.138] (helo=webserv.wug.de) by mrelayeu.kundenserver.de (node=mrelayeu8) with ESMTP (Nemesis), id 0ML31I-1HKg941fM6-0006af; Fri, 23 Feb 2007 20:31:54 +0100 Received: from kretschmer by webserv.wug.de with local (Exim 3.36 #1) id 1HKg93-0000XC-00 for pgsql-sql@postgresql.org; Fri, 23 Feb 2007 20:31:53 +0100 Date: Fri, 23 Feb 2007 20:31:53 +0100 From: "A. Kretschmer" To: pgsql-sql@postgresql.org Subject: Re: how do I to generate a sequence Range or Set of integer constants Message-ID: <20070223193153.GA1962@a-kretschmer.de> References: <200702231925.35411.pgsql@yukonho.de> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200702231925.35411.pgsql@yukonho.de> X-OS: Debian/GNU Linux - weil ich es mir Wert bin! X-Message-Flag: "Windows" is not the answer. "Windows" is the question and the answer is "no"! User-Agent: Mutt/1.5.9i X-Provags-ID: kundenserver.de abuse@kundenserver.de login:51ea9561fc3f6d9539a2acd743e4748c X-Provags-ID2: V01U2FsdGVkX1+0ZbDh9YbmwxhBHtNux+TOdT04O2eFM2qyFV7nuq1ff1EENzthFmHP3IOqNFcXsYuQUV/dhvMfNOLchOz2f9DKpt6ed+MjaNNMcDEiWSGcONEwtFcIzdYr X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.41 tagged_above=0 required=5 tests=AWL, BAYES_50, SPF_HELO_PASS X-Spam-Level: X-Archive-Number: 200702/239 X-Sequence-Number: 27573 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