Question about inserts

From: mike <mike(at)redtux1(dot)uklinux(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Question about inserts
Date: 2004-04-23 10:36:51
Message-ID: 1082716611.12125.24.camel@datacontrol
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stijn Vanroye 2004-04-23 11:07:43 Re: Question about inserts
Previous Message Peter Eisentraut 2004-04-23 10:06:12 Re: Unicode + LC_COLLATE