lundi 20 avril 2015

Creating a Null relational date type in PostgreSQL

I am converting a MySQL application that contains relationals of the form:

mydate < '2000-01-01'::date

MySQL will return true in this instance if mydate is Null and PostgreSQL will not. There are thousands of lines like this, too many and too varied to modify. I am investigating using a custom type to emulate this behavior, and I would like to utilize built-in I/O functions for Date as a base instead of rolling my own. Am I on the right track, and where do I find the documentation for them?

Aucun commentaire:

Enregistrer un commentaire