Received: from presence1.observatoiredesmarques.fr (presence1.observatoiredesmarques.fr [212.73.199.68]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f8H8K6788083 for ; Mon, 17 Sep 2001 04:20:06 -0400 (EDT) (envelope-from richard@presenceweb.com) Received: from presenceweb.com (gatei.observatoiredesmarques.fr [213.56.32.22]) by presence1.observatoiredesmarques.fr (8.9.1/_ODM_070798) with ESMTP id HAA19823; Mon, 17 Sep 2001 07:55:05 GMT Message-ID: <3BA5AA17.2C6834B9@presenceweb.com> Date: Mon, 17 Sep 2001 09:45:27 +0200 From: Richard NAGY Organization: Presenceweb X-Mailer: Mozilla 4.72 [fr] (X11; U; Linux 2.2.14-6.1.1smp i686) X-Accept-Language: fr, en MIME-Version: 1.0 To: Josh Berkus CC: pgsql-sql@postgresql.org Subject: Re: SQL request change when upgrade from 7.0.2 to 7.1.3 References: Content-Type: multipart/alternative; boundary="------------0659DE52D6245E4AF9D96201" X-Archive-Number: 200109/98 X-Sequence-Number: 4762 --------------0659DE52D6245E4AF9D96201 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Josh Berkus a écrit : > Richard, > > I'm curious now. What happens if you remove the table qualifications, > e.g.: > > ORDER BY type, nom; > > -Josh > > ______AGLIO DATABASE SOLUTIONS___________________________ > Josh Berkus > Complete information technology josh@agliodbs.com > and data management solutions (415) 565-7293 > for law firms, small businesses fax 621-2533 > and non-profit organizations. San Francisco Hello Josh, Yes, it works! I don't know exactly why, but it works! Thanks a lot. -- Richard NAGY Presenceweb --------------0659DE52D6245E4AF9D96201 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Josh Berkus a écrit :
Richard,

I'm curious now.  What happens if you remove the table qualifications,
e.g.:

ORDER BY type, nom;

-Josh

______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco

Hello Josh,

Yes, it works! I don't know exactly why, but it works!
Thanks a lot.

--
Richard NAGY
Presenceweb
  --------------0659DE52D6245E4AF9D96201--