parity with sqlite version, running through postgres