PostgreSQL ~* operator

[asarch]

How would you implement that operator? E.g:

select * from foo where name ~* 'baz';

[fukamachi]

Unfortunately, not supported yet.

To add such an infix operator, add a line to operator.lisp.

Or, :raw is available to make it work without any changes:

(select :* (from :foo) (where (:raw "name ~* 'baz'")))