Inserting NULL into Integer column

From: "Jeremy Smith" <jer(at)highboard(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Inserting NULL into Integer column
Date: 2004-02-18 19:25:19
Message-ID: FKEOIJEHOIKIOEHCGNCLEEMEEDAA.jer@highboard.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Rod Taylor 2004-02-18 19:27:56 Re: [PATCHES] NO WAIT ...
Previous Message Larry Rosenman 2004-02-18 19:19:03 Re: [PATCHES] NO WAIT ...

Browse pgsql-sql by date

  From Date Subject
Next Message scott.marlowe 2004-02-18 19:43:34 Re: Inserting NULL into Integer column
Previous Message Jeremy Smith 2004-02-18 18:06:32 Re: CHAR(n) always trims trailing spaces in 7.4