| From: | Sergey Konoplev <gray(dot)ru(at)gmail(dot)com> |
|---|---|
| To: | "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: regexp operator for array element compares needed |
| Date: | 2012-04-13 13:33:16 |
| Message-ID: | CAL_0b1saNcVhxGxnfmpB0EpD9OLkKuVUZJXe10NBZQnSHFpZZA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Apr 12, 2012 at 10:50 PM, Gauthier, Dave
<dave(dot)gauthier(at)intel(dot)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(dot)ru(at)gmail(dot)com Skype: gray-hemp
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Paulo Correia | 2012-04-13 13:38:15 | Postgres 9.0 Streaming Replication and Load Balancing? |
| Previous Message | Sergey Konoplev | 2012-04-13 13:19:43 | Re: Value to long for type ....: Columnname missing |