Re: [SQL] Database views metadata always nullable columns

Поиск
Список
Период
Сортировка
От basuraspam -
Тема Re: [SQL] Database views metadata always nullable columns
Дата
Msg-id CAAMZiXDhAKarRcL-ajTPMqVVSVZ7aYBZD2pDQ7wLYWhpd2g1kg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [SQL] Database views metadata always nullable columns  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: [SQL] Using bind variable within BEGIN END
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: YNT: Re: [SQL] Using bind variable within BEGIN END