Is it possible to to the following I have tables which are updated via webpage (perl) with fields of type int and date (all nullable). If the values are blank the entire insert fails, with a wrong type error. Is there any way to stop this behaviour so that the valid information is allowed,but the blank values get ignored. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html