Obrigado Osvaldo exatamente o que precisava apenas adaptei a minha necessidade
SELECT nome FROM cad WHERE nome ~* '[[:<:]]farmacia[[:>:]]' 2011/9/16 Osvaldo Kussama <[email protected]> > bdteste=# SELECT regexp_matches(x, '[[:<:]]foo[[:>:]]') FROM (VALUES > ('foo'), ('foofoo'), ('foofoofoo'), ('ofo'), ('ofoofo'), > ('ofoofoofo')) AS f(x); > regexp_matches > ---------------- > {foo} > (1 row) > > > http://www.postgresql.org/docs/current/interactive/functions-matching.html#FUNCTIONS-POSIX-REGEXP > > Osvaldo > >
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
