Re: SHOW command always returns text field - Mailing list pgsql-hackers

From Tom Lane
Subject Re: SHOW command always returns text field
Date
Msg-id 15666.1313002200@sss.pgh.pa.us
Whole thread Raw
In response to Re: SHOW command always returns text field  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Excerpts from Tom Lane's message of mié ago 10 14:12:49 -0400 2011:
>> Peter Eisentraut <peter_e@gmx.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


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: sha1, sha2 functions into core?
Next
From: Heikki Linnakangas
Date:
Subject: Re: "pgstat wait timeout" warnings