Fix the Problem with like. Solution from User ale2317 (see Issue #118).

tds-fdw / tds_fdw

A PostgreSQL foreign data wrapper to connect to TDS databases (Sybase and Microsoft SQL Server)

Other

381 stars 102 forks source link

Fix the Problem with like. Solution from User ale2317 (see Issue #118). #158

Closed bullwasher closed 6 years ago

bullwasher commented 6 years ago

From https://www.postgresql.org/docs/8.2/static/functions-matching.html: The operator ~~ is equivalent to LIKE, and \~~ corresponds to ILIKE. There are also !~~ and !~~ operators that represent NOT LIKE and NOT ILIKE, respectively. All of these operators are PostgreSQL-specific.

jenkins-juliogonzalez commented 6 years ago

Can one of the admins verify this patch?

GeoffMontee commented 6 years ago

Test this, please

jenkins-juliogonzalez commented 6 years ago

Test PASSed.

GeoffMontee commented 6 years ago

Thanks for the fix!