Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 2409D860809 for ; Tue, 24 Apr 2012 13:06:38 -0300 (ADT) Received: from mailout04.ims-firmen.de ([213.174.32.250]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SMiGB-0000zu-Rr for pgsql-sql@postgresql.org; Tue, 24 Apr 2012 16:06:37 +0000 Received: from mailin04.ims-firmen.de ([192.168.1.144]) by mailout02.ims-firmen.de with esmtp (envelope-from ) id 1SMiFz-0003sk-3o for pgsql-sql@postgresql.org; Tue, 24 Apr 2012 18:06:23 +0200 Received: from [87.170.185.237] (helo=a-kretschmer.de) by mailin04.ims-firmen.de with esmtpsa (TLSv1:AES256-SHA:256) (envelope-from ) id 1SMiEW-0002R5-5d for pgsql-sql@postgresql.org; Tue, 24 Apr 2012 18:04:52 +0200 Received: from kretschmer by a-kretschmer.de with local (Exim 4.69) (envelope-from ) id 1SMiFx-0003g7-O9 for pgsql-sql@postgresql.org; Tue, 24 Apr 2012 18:06:21 +0200 Date: Tue, 24 Apr 2012 18:06:21 +0200 From: Andreas Kretschmer To: pgsql-sql@postgresql.org Subject: Re: Simple way to get missing number Message-ID: <20120424160621.GA14023@tux> References: <4F96B57E.8080306@encs.concordia.ca> <20120424143655.GA7501@tux> <201204242059.40709.raju@linux-delhi.org> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <201204242059.40709.raju@linux-delhi.org> X-OS: Debian/GNU Linux - weil ich es mir Wert bin! X-GPG-Fingerprint: EE16 3C01 7B9C 10F7 2C8B 3B86 4DB3 D9EE 7F45 84DA X-Message-Flag: "Windows" is not the answer. "Windows" is the question and the answer is "no"! X-Lugdd: Gerd Kube X-Info: My name is root. Just root. And I am licensed to kill -9 User-Agent: Mutt/1.5.18 (2008-05-17) X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201204/53 X-Sequence-Number: 36530 Raj Mathur (राज माथुर) wrote: > > Nice one, but curious about how would this perform if the numbers in > question extended into 7 figures or more? TIAS (Try It And See) Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknown) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°