public inbox for [email protected]  

help / color / mirror / Atom feed

From: Laurenz Albe <[email protected]>
To: [email protected]
To: [email protected]
Subject: Re: is_nullable column of information_schema.columns table
Date: Tue, 07 Jan 2020 11:41:29 +0100
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

On Sat, 2019-12-28 at 20:19 +0000, PG Doc comments form wrote:
> Page: https://www.postgresql.org/docs/12/infoschema-columns.html
> Description:
> 
> is_nullable column of information_schema.columns table does not show correct
> values for columns of views. For tables that column shows correct values
> whether a column is nullable or not. I think the documentation should
> include this information although better solution is to correct that error.

All columns of a view are defined as nullable, whether they can assume
that value or not.  PostgreSQL does not attempt to deduce the nullability
of columns from the view definition.

So the information in information_schema.columns is correct.
Remember that nullability does not imply that there are actually NULL values.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com

view thread (3+ messages)

reply

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: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: is_nullable column of information_schema.columns table
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox