NULL as a (pseudo-)value not described?

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

Responses

Browse pgsql-docs by date

  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?