Re: regexp operator for array element compares needed

Поиск
Список
Период
Сортировка
От Sergey Konoplev
Тема Re: regexp operator for array element compares needed
Дата
Msg-id CAL_0b1saNcVhxGxnfmpB0EpD9OLkKuVUZJXe10NBZQnSHFpZZA@mail.gmail.com
обсуждение исходный текст
Ответ на regexp operator for array element compares needed  ("Gauthier, Dave" <dave.gauthier@intel.com>)
Список pgsql-general
On Thu, Apr 12, 2012 at 10:50 PM, Gauthier, Dave
<dave.gauthier@intel.com> wrote:
> ... from 'a.,b.,c*,d*,ee'

You can not do like this.

> Don't even know if this sort of thing is possible.  I didn't see any
> operator like this in the docs.  May have to split out each and compare in
> nested loops sith atomic regexp compare "~".

Probably you will find the ltree extension useful
http://www.postgresql.org/docs/9.1/interactive/ltree.html, though it
does not provide fully functional regexps.


--
Sergey Konoplev

Blog: http://gray-hemp.blogspot.com
LinkedIn: http://ru.linkedin.com/in/grayhemp
JID/GTalk: gray.ru@gmail.com Skype: gray-hemp

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

Предыдущее
От: Sergey Konoplev
Дата:
Сообщение: Re: Value to long for type ....: Columnname missing
Следующее
От: Paulo Correia
Дата:
Сообщение: Postgres 9.0 Streaming Replication and Load Balancing?