Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f5CHJTE63212 for ; Tue, 12 Jun 2001 13:19:29 -0400 (EDT) (envelope-from pgsql-general-owner@postgresql.org) Received: from bubbles.electricutopia.net (bubbles.electricutopia.net [63.214.178.76]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5BNOFE37903; Mon, 11 Jun 2001 19:24:15 -0400 (EDT) (envelope-from dave@slickness.org) Received: from localhost (dave@localhost) by bubbles.electricutopia.net (8.9.3/8.9.3) with ESMTP id QAA03026; Mon, 11 Jun 2001 16:23:29 -0700 Date: Mon, 11 Jun 2001 16:23:29 -0700 (PDT) From: David Olbersen X-X-Sender: To: =?iso-8859-1?q?Mart=EDn=20Marqu=E9s?= cc: pgsql sql Mailing List , Subject: Re: [SQL] ORDER BY what? In-Reply-To: <01061111193103.29653@bugs> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from QUOTED-PRINTABLE to 8bit by postgresql.org id f5BNOGF37905 X-Archive-Number: 200106/422 X-Sequence-Number: 10803 On Mon, 11 Jun 2001, Martín Marqués wrote: > My question is: "How can I write an ORDER BY statment so that it's ordered by > the amount of matches it gets?" Your question is a bit unclear, what is "it"? Specifically, what are the "it's" that are to be ordered, and which "it" gets matches? -- Dave