Re: Figure out nullability of query parameters - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: Figure out nullability of query parameters
Date
Msg-id CAKAnmm+aicuaU7cgEuFb_hwWSPirwv6omnFHhPRfwoOvUh-PjA@mail.gmail.com
Whole thread Raw
In response to Re: Figure out nullability of query parameters  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
It would be really handy to know that `$1` is being used as a non nullable value

To push back in a different way, how exactly would this be useful?

The system catalogs are the best place to get all the various information about a relation, including any and all constraints. Data type info via protocol, yes, but constraints seems a whole other level of bother.

Cheers,
Greg

--
Enterprise Postgres Software Products & Tech Support

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Figure out nullability of query parameters
Next
From: Adrian Klaver
Date:
Subject: Re: analyze-in-stages post upgrade questions