Re: find a string contained in an attribute

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Karina Guardado <kguardado(at)gmail(dot)com>
Cc: Szymon Guz <mabewlun(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: find a string contained in an attribute
Date: 2010-03-25 15:04:38
Message-ID: 162867791003250804i346c8933sae83b2687c1300f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

http://www.postgresql.org/docs/8.4/static/textsearch.html

Regards
Pavel Stehule

2010/3/25 Karina Guardado <kguardado(at)gmail(dot)com>:
> Do you have a link where I can read more about this because is not easy to
> understand.
>
> Thanks for your help,
>
> karina
>
> On Thu, Mar 25, 2010 at 1:34 AM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
> wrote:
>>
>> 2010/3/24 Szymon Guz <mabewlun(at)gmail(dot)com>:
>> > 2010/3/24 Karina Guardado <kguardado(at)gmail(dot)com>
>> >>
>> >> Hi,
>> >>
>> >> I want to know if it is possible to search for a string of characters
>> >> inside an attribute for example I have the following table and values
>> >>
>> >> cod_unidad |                 nombre_uni
>> >> ------------+---------------------------------------------
>> >>           1 | Facultad de Ciencias Naturales y Matemática
>> >>           2 | Facultad de Ciencias Humanidades
>> >>           3 | Facultad de Ingeniería
>> >>           4 | Facultad de Agronomía
>> >>           5 | Oficinas Centrales
>> >>           6 | test
>> >>
>> >>
>> >> I want to retrieve all the rows where I find the word Ciencias for
>> >> example. Is there a function or with select is possible to do it?
>> >>
>> >> thanks in advance,
>> >>
>> >> karina
>> >> El Salvador, Centroamerica
>> >
>> > For example something like this should work:
>> > SELECT * FROM table WHERE nombre_uni like '%Ciencias%';
>> > more you can find
>> >
>> > here: http://www.postgresql.org/docs/8.4/interactive/functions-matching.html
>> > regards
>> > Szymon Guz
>>
>> better to use a fulltext it is much faster on tables larger than small
>>
>> create index foo on tab using gin(to_tsvector('simple', nombre_uni))
>>
>> select * from tab where to_tsvector('simple', nombre_uni) @@
>> to_tsquery('simple', 'Ciencias');
>>
>> Regards
>> Pavel Stehule
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tadipathri Raghu 2010-03-25 15:11:16 Re: How many Mandatory Process are there in Postgres
Previous Message Karina Guardado 2010-03-25 14:39:11 Re: find a string contained in an attribute