Re: [SQL] Database views metadata always nullable columns - Mailing list pgsql-sql

From basuraspam -
Subject Re: [SQL] Database views metadata always nullable columns
Date
Msg-id CAAMZiXDhAKarRcL-ajTPMqVVSVZ7aYBZD2pDQ7wLYWhpd2g1kg@mail.gmail.com
Whole thread Raw
In response to Re: [SQL] Database views metadata always nullable columns  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Thanks guys for your feedback... I'll try to dig a bit more about how to setup the EXPLAIN view "trick" scenario...
Regards,

2017-06-02 18:07 GMT+02:00 Tom Lane <tgl@sss.pgh.pa.us>:
basuraspam - <basuraspam0@gmail.com> writes:
>    I agree, it would be better including an example. The "issue" I reported
> is with database views not with tables. Taking your example as base:

>  create table foo (f1 int, f2 int not null);
>  create view foo_view as select * from foo;

Ah, gotcha.  No, sorry, we do not track nullability of view columns as
such.

                        regards, tom lane

pgsql-sql by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: [SQL] Using bind variable within BEGIN END
Next
From: Adrian Klaver
Date:
Subject: Re: YNT: Re: [SQL] Using bind variable within BEGIN END