Re: Blank Numeric Column For INSERT - Mailing list pgsql-general

From Rich Shepard
Subject Re: Blank Numeric Column For INSERT
Date
Msg-id alpine.LNX.2.00.1111231258000.28204@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: Blank Numeric Column For INSERT  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Jay Levitt
Date:
Subject: PGError: ERROR: could not open relation with OID?
Next
From: Antonio Franzoso
Date:
Subject: Compiler does not detect support for 64 bit integers