From: Jeremy Smith <jer@highboard.com>
To: pgsql-sql@postgresql.org
Subject: Inserting NULL into Integer column
Date: Wed, 18 Feb 2004 14:25:19 -0500
Message-ID: <FKEOIJEHOIKIOEHCGNCLEEMEEDAA.jer@highboard.com> (raw)
In-Reply-To: <FKEOIJEHOIKIOEHCGNCLKEMBEDAA.jer@highboard.com>
Hi,
in mysql I was able to make an insert such as:
INSERT INTO TABLE (integervariable) VALUES ('')
and have it either insert that variable, or insert the default if it had
been assigned. In postgresql it gives and error every time that this is
attempted. Since I have so many queries that do this on my site already, is
there any way to set up a table so that it just accepts this sort of query?
Thanks,
Jeremy
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jer@highboard.com
Subject: Re: Inserting NULL into Integer column
In-Reply-To: <FKEOIJEHOIKIOEHCGNCLEEMEEDAA.jer@highboard.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox