Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 2424863289B for ; Tue, 22 Dec 2009 03:19:46 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 93000-05 for ; Tue, 22 Dec 2009 07:19:27 +0000 (UTC) X-Greylist: delayed 00:07:46.31081 by SQLgrey-1.7.6 Received: from forward15.mail.yandex.net (forward15.mail.yandex.net [95.108.130.119]) by mail.postgresql.org (Postfix) with ESMTP id 70C80632A1B for ; Tue, 22 Dec 2009 03:19:30 -0400 (AST) Received: from webmail111.yandex.ru (webmail111.yandex.ru [95.108.131.134]) by forward15.mail.yandex.net (Yandex) with ESMTP id A9178C0D67; Tue, 22 Dec 2009 10:11:41 +0300 (MSK) Received: from localhost (localhost.localdomain [127.0.0.1]) by webmail111.yandex.ru (Yandex) with ESMTP id 883FC2BC4100; Tue, 22 Dec 2009 10:11:41 +0300 (MSK) X-Yandex-Spam: 1 X-Yandex-Front: webmail111 X-Yandex-TimeMark: 1261465901 Received: from user-22.81.118.217.in-addr.arpa (user-22.81.118.217.in-addr.arpa [217.118.81.22]) by mail.yandex.ru with HTTP; Tue, 22 Dec 2009 10:11:41 +0300 From: msi77 To: Gary Chambers ,pgsql-sql@postgresql.org In-Reply-To: <302670f20912211415n4fc73b04x19eebfb9ff0acd60@mail.gmail.com> References: <302670f20912211415n4fc73b04x19eebfb9ff0acd60@mail.gmail.com> Subject: Re: 8.4.1 distinct query WITHOUT order by MIME-Version: 1.0 Message-Id: <10421261465901@webmail111.yandex.ru> Date: Tue, 22 Dec 2009 10:11:41 +0300 X-Mailer: Yamail [ http://yandex.ru ] 5.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=-10 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200912/54 X-Sequence-Number: 33492 > What are the ramifications of renaming the table (containing 8000 > rows) and creating a view of the same name? View does not admit ORDER BY clause, at least, Standard does not. Sergey