Re: [SQL] ORDER BY what?
От | Martín Marqués |
---|---|
Тема | Re: [SQL] ORDER BY what? |
Дата | |
Msg-id | 01061311265400.08685@bugs обсуждение исходный текст |
Ответ на | Re: [SQL] ORDER BY what? (Bruno Wolff III <bruno@wolff.to>) |
Ответы |
Re: [SQL] ORDER BY what?
Re: Re: [SQL] ORDER BY what? |
Список | pgsql-general |
On Mié 13 Jun 2001 16:16, Bruno Wolff III wrote: > On Tue, Jun 12, 2001 at 03:53:22PM +0300, > > > > > 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. > > You could do this by computing a value based on the number of parts > that matched and order by it. Could you give me a hint on this? Do I have to use PLSQL? Triggers? Something else? Thanks for the responce. 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 -----------------------------------------------------------------
В списке pgsql-general по дате отправления: