Re: SHOW command always returns text field

Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> Excerpts from Tom Lane's message of mi ago 10 14:12:49 -0400 2011:
>> Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
>>> I was slightly surprised the other day that the SHOW command always
>>> returns a field of type text even if the underlying parameter has one of
>>> the other types (int, real, etc.). Is this intentional? Would it be
>>> worth refining?

>> I'm disinclined to mess with it. One thing that couldn't easily be
>> "cleaned up" is the textual output for nominally-numeric parameters
>> that have units.

> How about having it return a record?

I think that's already covered by the pg_settings view. The question is
whether plain SHOW ought to change. I don't see the point.

regards, tom lane