Received: from seamus.acmehost.com (acmehost.com [64.71.190.160]) by postgresql.org (Postfix) with ESMTP id 916BF4763E5 for ; Thu, 11 Apr 2002 18:16:42 -0400 (EDT) Received: from eric (yeti@12-250-221-87.client.attbi.com [12.250.221.87]) by seamus.acmehost.com (8.12.2/8.12.2) with SMTP id g3BMGTcg032361 for ; Thu, 11 Apr 2002 15:16:30 -0700 From: "Eric Carpenter" To: Subject: Inserting values into numeric fields Date: Thu, 11 Apr 2002 17:16:37 -0500 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 In-Reply-To: <200204111109.12ab@th00.opsion.fr> Importance: Normal X-Archive-Number: 200204/143 X-Sequence-Number: 7408 Greetings all, I'm trying to insert values into a numeric field which may be optional. I'm using perl's DBI and bind parameters to do this. However, psotgresql complains that '' is not a numeric, since the DBI quotes everything before inserting.. I've tried inserting NULL as well, but that gets quoted and rejected as well. Is there any way to do this without hard coding "NULL" into the prepared statement handle? Thanks! Eric Carpenter