Queries with Regular Expressions

Поиск
Список
Период
Сортировка
От Silas Justiniano
Тема Queries with Regular Expressions
Дата
Msg-id 58e3b9040604061258i4ca50e18w805b0be416d3a6f0@mail.gmail.com
обсуждение исходный текст
Ответы Re: Queries with Regular Expressions  ("John D. Burger" <john@mitre.org>)
Список pgsql-general
Hello!

My queries work fine with Regular Expressions, as:

SELECT field FROM table WHERE field ~ 'something';
SELECT field FROM table WHERE field ~* 'something';
SELECT field FROM table WHERE field ~* 'som[i,e]thing';

And it works fine for special characters:
SELECT field FROM table WHERE field ~* 'chão';

But I just can't make it work correctly using brackets:
SELECT field FROM table WHERE field ~* 'ch[aã]o';

It just returns tuples that have 'chao', but not 'chão'.

My queries are utf-8 an the database is SQL_ASCII.

Any idea? Thank you!

--
Silas Justiniano - Brazil

В списке pgsql-general по дате отправления:

Предыдущее
От: Terry Lee Tucker
Дата:
Сообщение: Re: Running Command Line From Trigger?
Следующее
От: Bill Moseley
Дата:
Сообщение: Re: plgpsql and transactions