Re: Blank Numeric Column For INSERT

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Blank Numeric Column For INSERT
Date: 2011-11-23 20:59:58
Message-ID: alpine.LNX.2.00.1111231258000.28204@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2011-11-23 21:35:33 Re: plpgsql Difference in behaviour between versions?
Previous Message Jay Levitt 2011-11-23 20:52:20 PGError: ERROR: could not open relation with OID?