Inserting NULL into Integer column - Mailing list pgsql-sql

From Jeremy Smith
Subject Inserting NULL into Integer column
Date
Msg-id FKEOIJEHOIKIOEHCGNCLEEMEEDAA.jer@highboard.com
Whole thread Raw
In response to Re: CHAR(n) always trims trailing spaces in 7.4  ("Jeremy Smith" <jer@highboard.com>)
Responses Re: Inserting NULL into Integer column  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-sql
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



pgsql-sql by date:

Previous
From: "Jeremy Smith"
Date:
Subject: Re: CHAR(n) always trims trailing spaces in 7.4
Next
From: "scott.marlowe"
Date:
Subject: Re: Inserting NULL into Integer column