Re: Blank Numeric Column For INSERT

Поиск
Список
Период
Сортировка
От Rich Shepard
Тема Re: Blank Numeric Column For INSERT
Дата
Msg-id alpine.LNX.2.00.1111231258000.28204@salmo.appl-ecosys.com
обсуждение исходный текст
Ответ на Re: Blank Numeric Column For INSERT  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Wed, 23 Nov 2011, Tom Lane wrote:

> In an insert command, you need to either write NULL or omit the column
> from the column list; empty expressions aren't syntactically correct.
> (Note that the latter option actually results in inserting the column's
> default, not necessarily null...)

Tom,

   I must have written Null rather than NULL yesterday evening. That's why
it didn't work for me.

   Must be some other glitches but they scroll up too quickly to read. I'll
fix those next.

   Many thanks. Happy Thanksgiving.

Rich

В списке pgsql-general по дате отправления:

Предыдущее
От: Jay Levitt
Дата:
Сообщение: PGError: ERROR: could not open relation with OID?
Следующее
От: Antonio Franzoso
Дата:
Сообщение: Compiler does not detect support for 64 bit integers