Re: show all; - Mailing list pgsql-patches

From Tom Lane
Subject Re: show all;
Date
Msg-id 9979.991432709@sss.pgh.pa.us
Whole thread Raw
In response to Re: show all;  (Marko Kreen <marko@l-t.ee>)
List pgsql-patches
Marko Kreen <marko@l-t.ee> writes:
> Another thing: currently the var display goes through
> elog(NOTICE) and is quite verbose.  Is it possible to
> return those as a list of tuples? (name, value)

This would be a good idea, but I don't think there's any non-kluge
way to do it at the moment.

The right way to do it would be as a function returning a set of tuples,
which you might then bury inside a VIEW for syntactic convenience.
While that's certainly possible (SQL functions do it), it's a pain in
the neck to code and the interface is likely to change drastically
sometime soon.  So I'd recommend holding that idea on the to-do list
until we do something about the function-returning-tuples problem.

            regards, tom lane

pgsql-patches by date:

Previous
From: Marko Kreen
Date:
Subject: Re: unary plus
Next
From: Marko Kreen
Date:
Subject: Re: show all;