From: John Lumby <johnlumby@hotmail.com>
To: postgresql docmaillist <pgsql-docs@postgresql.org>
Subject: NULL as a (pseudo-)value not described?
Date: Wed, 10 Sep 2014 17:51:32 -0400
Message-ID: <BAY175-W4881B8F05E83A4ACA02771A3CF0@phx.gbl> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-docs>
As far as I can tell,
the un-value NULL is not described anywhere in the doc
as being something that can be assigned to a column.
E.g. :
. not listed as a constant (well that's reasonable as it isn't)
. not listed as an expression (is NULL an expression?)
. not explicitly listed under the INSERT and UPDATE commands
as a valid syntactic unit as an alternative to an expression
(If it is not an expression)
I do see it listed as a valid keyword but there is no description there.
To put it another way, the following syntax is apparently not permitted :
UPDATE my_nullable_table SET nullable_col = NULL;
(I am not referring to other null-related constructs such as IS NULL, IFNULL etc)
I have to assume I'm missing something?
Or is it that NULL is so, well, null, that it cannot be described?
John
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: johnlumby@hotmail.com
Subject: Re: NULL as a (pseudo-)value not described?
In-Reply-To: <BAY175-W4881B8F05E83A4ACA02771A3CF0@phx.gbl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox