ORDER BY what?

From: Martín Marqués <martin(at)bugs(dot)unl(dot)edu(dot)ar>
To: pgsql sql Mailing List <pgsql-sql(at)postgresql(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: ORDER BY what?
Date: 2001-06-11 08:19:31
Message-ID: 01061111193103.29653@bugs
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

I have a quite complex select query on postgres (obviously :-) ) using PHP
(which is not the problem at the moment) which has some text searches using
LIKE.
My question is: "How can I write an ORDER BY statment so that it's ordered by
the amount of matches it gets?"
Is this posible without getting ichy with the programing?

Saludos.... :-)

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marc SCHAEFER 2001-06-11 08:25:45 Re: foreign keys constraints, depending on each other
Previous Message Einar Karttunen 2001-06-11 07:46:48 RE: libpq compile error

Browse pgsql-sql by date

  From Date Subject
Next Message Hartwig Jens 2001-06-11 08:41:15 RE: GRANT EXECUTE
Previous Message Bruce Momjian 2001-06-11 04:54:06 Re: Yet another Postgresql article...