Add POSIX operator support for Postgres

Closes #562, Closes #561
Use chai throw assertions instead of manual try catch