>
> 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
Really???
Testing on Windows 9.0.4 this expression returns FALSE, not true as you
claim. Please try again and reply with detailed version information and the
exact query(s) used if you can get the behavior to repeat itself.
David J.