find a string contained in an attribute

2010/3/24 Karina Guardado <kguardado@gmail.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

2010/3/24 Szymon Guz <mabewlun@gmail.com>:

2010/3/24 Karina Guardado <kguardado@gmail.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

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.stehule@gmail.com>
wrote:

2010/3/24 Szymon Guz <mabewlun@gmail.com>:

2010/3/24 Karina Guardado <kguardado@gmail.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