pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Martín Marqués <martin@bugs.unl.edu.ar>
To: David Olbersen <dave@slickness.org>
Cc: pgsql sql Mailing List <pgsql-sql@postgresql.org>
Cc: pgsql-general@postgresql.org
Subject: Re: [SQL] ORDER BY what?
Date: Tue, 12 Jun 2001 15:53:22 +0300
Message-ID: <01061215532200.04895@bugs> (raw)
In-Reply-To: <Pine.LNX.4.31.0106111622110.2923-100000@bubbles.electricutopia.net>
References: <Pine.LNX.4.31.0106111622110.2923-100000@bubbles.electricutopia.net>

On Mar 12 Jun 2001 02:23, David Olbersen wrote:
> 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?

OK, let me give an example:

select * from tab1 where col1 like '%word%' or col2 like '%word%' and col3 
like '%word%'

and I want to order by the amopunt of matches that a matching register has. 
Something like, if it matches all the ORs, then it should go first, and if it 
matches only one of the ORs it should go last.
Or maybe even have several words trying to match one of the columns.

Saludos... :-)

-- 
Cualquiera administra un NT.
Ese es el problema, que cualquiera administre.
-----------------------------------------------------------------
Martin Marques                  |        mmarques@unl.edu.ar
Programador, Administrador      |       Centro de Telematica
                       Universidad Nacional
                            del Litoral
-----------------------------------------------------------------



view thread (9+ messages)  latest in thread

Message-ID: <01061215532200.04895@bugs>
Permalink:  ../01061215532200.04895@bugs/
Also on:    postgresql.org/message-id/01061215532200.04895@bugs

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: martin@bugs.unl.edu.ar, dave@slickness.org, pgsql-general@postgresql.org
  Subject: Re: [SQL] ORDER BY what?
  In-Reply-To: <01061215532200.04895@bugs>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox