Re: libpq, PQdescribePrepared -> PQftype, PQfmod, no PQnullable - Mailing list pgsql-hackers

Florian Pflug <fgp@phlo.org> writes:
> On Oct9, 2011, at 14:20 , Kevin Grittner wrote:
>> Yeah.  It would be nice to see at least one use case.  The only
>> comment I recall is a vague suggestion that that people might want to
>> select data from a table and infer table attributes from the result
>> set metadata.  That seems marginal.

> Well, there is one other, namely SQL standards compliance. It does
> mandate that "CREATE TABLE ... AS SELECT" creates NOT NULL constraints
> on non-nullable columns I think (I didn't re-check, though). I'm not sure
> I see the value in that either, but, hey, standards compliance ought
> to be a value it in itself, right?

Um ... but that case has nothing to do with protocol changes.
        regards, tom lane