From: | John Lumby <johnlumby(at)hotmail(dot)com> |
---|---|
To: | postgresql docmaillist <pgsql-docs(at)postgresql(dot)org> |
Subject: | NULL as a (pseudo-)value not described? |
Date: | 2014-09-10 21:51:32 |
Message-ID: | BAY175-W4881B8F05E83A4ACA02771A3CF0@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-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
From | Date | Subject | |
---|---|---|---|
Next Message | David Johnston | 2014-09-11 00:09:30 | Re: [9.3] Should we mention "set_config(...)" in 18.1.3 in Server Configuration? |
Previous Message | Bruce Momjian | 2014-09-10 20:20:02 | Re: [9.3] Should we mention "set_config(...)" in 18.1.3 in Server Configuration? |