Rel8.Expr.Text: the binary regular expression operator (~.) does not math the postgres operator

[Philoustic]

Hi

(~.) = binaryOperator "~."
should be
(~.) = binaryOperator "~"

[ocharles]

Ah, this is a bit unfortunate. The Rel8 naming convention is generally that Rel8 operates are suffixed with a .. For example, ==., and /=.. But then this doesn't really hold, because there isn't a SQL == operator anyway! But I'm not convinced this is /wrong/, per se, but agree it's mighty confusing.

[Philoustic]

Hmm, well yeah, but this operator should correspond to the postgresql '' operator... but instead it generates a ''.' in the sql query (as shown by showQuery) which otherwise fails with an sql error at runtime.
On the other hand, the '~*' works well.

So, for me, it this seems to be a typo in the string. "~." should be "~" .