Hi David,
On 12/20/2012 08:48 PM, David Johnston wrote:
-----Original Message-----
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
ow...@postgresql.org] On Behalf Of Denis Papathanasiou
Sent: Thursday, December 20, 2012 7:56 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Using POSIX Regular Expressions on xml type fields
gives
inconsistent results
[snip]
[At this point I'd confirm or question why ANY hasn't been made to go both
ways but also realize that I will have to approach this in a different way
to achieve my goal.]
I did realize that ANY() must be a right-hand operator, but what I
didn't understand (and admittedly still don't understand) is why regex
operations that are normally right-side work from the left.
If you look at the four examples which follow the posix match table in
the docs
(http://www.postgresql.org/docs/9.1/static/functions-matching.html#FUNCTIONS-POSIX-TABLE),
some of them work from the left side, e.g.:
'abc' ~ '(b|d)' true
In my original example, I found I could write this from left to right
like this, and it would still work:
'(b|d)' ~ 'abc' true
But when I reverse this expression:
'abc' ~ '^a' true
like this, it doesn't work:
'^a' ~ 'abc' false
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
