use this
regular expression
~
regular expression - case insensitive
~*
example
SELECT name FROM table1 where name
~* '*Ã*'
check here
http://www.postgresql.org/docs/current/static/functions-matching.html
--- El lun 23-jun-08, Ian Meyer
--- El lun 23-jun-08, Daniel Futerman <[EMAIL PROTECTED]> escribió:
De: Daniel Futerman <[EMAIL PROTECTED]>
Asunto: [GENERAL] Update Join Query
A: pgsql-general@postgresql.org
Fecha: lunes, 23 junio, 2008, 4:43 pm
Hi,
Looking for the correct syntax for an UPDATE LEFT JOIN query in PostgreSQL.
--- El lun 23-jun-08, Daniel Futerman <[EMAIL PROTECTED]> escribió:
De: Daniel Futerman <[EMAIL PROTECTED]>
Asunto: [GENERAL] Update Join Query
A: pgsql-general@postgresql.org
Fecha: lunes, 23 junio, 2008, 4:43 pm
Hi,
Looking for the correct syntax for an UPDATE LEFT JOIN query in PostgreSQL.