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

From Tom Lane
Subject Re: [SQL] Database views metadata always nullable columns
Date
Msg-id 23126.1496419637@sss.pgh.pa.us
Whole thread Raw
In response to Re: [SQL] Database views metadata always nullable columns  (basuraspam - <basuraspam0@gmail.com>)
Responses Re: [SQL] Database views metadata always nullable columns  (basuraspam - <basuraspam0@gmail.com>)
List pgsql-sql
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] Database views metadata always nullable columns
Next
From: anand086
Date:
Subject: Re: [SQL] Using bind variable within BEGIN END