Hello everyone.
I am working on a PHP/HTML front-end to a database, which is PostgreSQL. I have several date fields in my table, all with NOT NULL set to 'NO' (how's that for a double negative?). Yet when my web page goes to update the table, when I don't specify a date, I get ERROR: Bad date external representation ''.
How do I convince Postgres to accept a null for a date field?
thanks
allen
I am working on a PHP/HTML front-end to a database, which is PostgreSQL. I have several date fields in my table, all with NOT NULL set to 'NO' (how's that for a double negative?). Yet when my web page goes to update the table, when I don't specify a date, I get ERROR: Bad date external representation ''.
How do I convince Postgres to accept a null for a date field?
thanks
allen