Inserting NULL into Integer column

Поиск
Список
Период
Сортировка
От Jeremy Smith
Тема Inserting NULL into Integer column
Дата
Msg-id FKEOIJEHOIKIOEHCGNCLEEMEEDAA.jer@highboard.com
обсуждение исходный текст
Ответ на Re: CHAR(n) always trims trailing spaces in 7.4  ("Jeremy Smith" <jer@highboard.com>)
Ответы Re: Inserting NULL into Integer column  ("scott.marlowe" <scott.marlowe@ihs.com>)
Список 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 по дате отправления:

Предыдущее
От: "Jeremy Smith"
Дата:
Сообщение: Re: CHAR(n) always trims trailing spaces in 7.4
Следующее
От: "scott.marlowe"
Дата:
Сообщение: Re: Inserting NULL into Integer column