Inserting values into numeric fields - Mailing list pgsql-sql

From Eric Carpenter
Subject Inserting values into numeric fields
Date
Msg-id NHEMKPHJPKCCFEHFMEJIKECKCEAA.postgresql@slacker.to
Whole thread Raw
In response to Problem With A Rule  (<cnliou@eurosport.com>)
Responses Re: Inserting values into numeric fields  (Jason Earl <jason.earl@simplot.com>)
List pgsql-sql
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




pgsql-sql by date:

Previous
From: "Richard Ellerbrock"
Date:
Subject: Re: REPOST: Trouble with SQL conversion
Next
From: "Josh Berkus"
Date:
Subject: Re: Transactional vs. Read-only (Retrieval) database