Tk421 escribió: > The result is only record number 3. How can i search the entire > FOOBAR word? The result wanted must be all, excepting 5.
Something like this: select code from table where text ~ '[[:<:]]foobar[[:>:]]' -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
