> > 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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
