On 11/18/11 12:47 PM, John R Pierce wrote:
> does ~ have higher expression priority than || or something?
speaking of...
the precedence table [1] seems somewhat short of operators... the regex
operators like ~ ~* etc aren't on there, nor is string concatenation ||
... I'd expect the regex pattern ops like ~ should be with the LIKE
etc pattern matching, but apparently they are lumped in with 'everything
else' resulting in the anomalous behavior noted in the referenced thread...
[1]
http://www.postgresql.org/docs/current/static/sql-syntax-lexical.html#SQL-PRECEDENCE
--
john r pierce N 37, W 122
santa cruz ca mid-left coast