Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id E6C7C63391E for ; Mon, 6 Jul 2009 23:06:20 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 87890-03 for ; Mon, 6 Jul 2009 23:06:17 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from ns1.officenet.no (unknown [195.159.87.244]) by mail.postgresql.org (Postfix) with ESMTP id B4FA9632823 for ; Mon, 6 Jul 2009 23:06:17 -0300 (ADT) Received: from [192.168.2.102] (helo=andreak-laptop.localnet) by ns1.officenet.no with esmtpsa (TLS-1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.69) (envelope-from ) id 1MO04P-00085O-C7 for pgsql-sql@postgresql.org; Tue, 07 Jul 2009 04:06:14 +0200 From: Andreas Joseph Krogh Organization: OfficeNet AS To: pgsql-sql@postgresql.org Subject: Re: Order of "WITH RECURSIVE" output Date: Tue, 7 Jul 2009 04:06:07 +0200 User-Agent: KMail/1.12.0 (Linux/2.6.28-13-generic; KDE/4.2.95; i686; ; ) References: <200907070344.36084.andreak@officenet.no> <25601.1246931735@sss.pgh.pa.us> In-Reply-To: <25601.1246931735@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: Text/Plain; charset="iso-8859-15" Content-Transfer-Encoding: quoted-printable Message-Id: <200907070406.07619.andreak@officenet.no> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.1 tagged_above=0 required=5 tests=RDNS_NONE=0.1 X-Spam-Level: X-Archive-Number: 200907/20 X-Sequence-Number: 32761 On Tuesday 07 July 2009 03:55:35 am Tom Lane wrote: > Andreas Joseph Krogh writes: > > If I omit "ORDER BY", is the output *guaranteed* (according to some > > standard) to be ordered >=20 > No. It's not necessary to read any other details to answer that ... >=20 > regards, tom lane Ok, thanks for prompt reply. =2D-=20 Andreas Joseph Krogh Senior Software Developer / CTO =2D-----------------------+---------------------------------------------+ OfficeNet AS | The most difficult thing in the world is to | Rosenholmveien 25 | know how to do a thing and to watch | 1414 Troll=E5sen | somebody else doing it wrong, without | NORWAY | comment. | | | Tlf: +47 24 15 38 90 | | =46ax: +47 24 15 38 91 | | Mobile: +47 909 56 963 | | =2D-----------------------+---------------------------------------------+