Re: Blank Numeric Column For INSERT

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Blank Numeric Column For INSERT
Date: 2011-11-23 20:17:24
Message-ID: 2663.1322079444@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Rich Shepard <rshepard(at)appl-ecosys(dot)com> writes:
> Mine do, too. But, that's not what postgres wants to see in the .sql file.

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...)

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jay Levitt 2011-11-23 20:52:20 PGError: ERROR: could not open relation with OID?
Previous Message Rich Shepard 2011-11-23 20:10:55 Re: Blank Numeric Column For INSERT