Re: Find out if a parameter/return field is NULLABLE

Поиск
Список
Период
Сортировка
От Kris Jurka
Тема Re: Find out if a parameter/return field is NULLABLE
Дата
Msg-id Pine.BSO.4.61.0601301834500.19902@leary.csoft.net
обсуждение исходный текст
Ответ на Re: Find out if a parameter/return field is NULLABLE using Describe  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-interfaces

On Mon, 30 Jan 2006, Tom Lane wrote:

> Richard Jones <rich@annexia.org> writes:
>> It doesn't seem to be possible to find out if a parameter or result
>> field is nullable using the Describe protocol.
>
> This isn't something that the backend tracks at all, so changing the
> wire protocol would be the least of your problems in making it happen...
>

Well, the protocol does attempt to return the resulting columns' source 
table and column number which may then be used to determine the 
nullability of the field.  This won't work in all cases, but for the 
simple select example given, it will.

Kris Jurka


В списке pgsql-interfaces по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Find out if a parameter/return field is NULLABLE using Describe
Следующее
От: Judith Retief
Дата:
Сообщение: sql listen fails using libpgtcl