On Sun, Apr 05, 2009 at 05:57:46PM -0700, David Fetter wrote:
> On Sun, Apr 05, 2009 at 08:55:07PM -0400, Tom Lane wrote:
> > David Fetter <da...@fetter.org> writes:
> > > On Sun, Apr 05, 2009 at 02:07:32PM -0400, Tom Lane wrote:
> > >> The \df thing? That's something it'd be okay to revisit during
> > >> beta, IMHO.
> >
> > > OK, I'll work on this tomorrow :)
> >
> > I think what we were lacking was consensus on what it should do, not
> > code ...
>
> I was thinking I'd knock out a proposal or two.
Please find enclosed one way to handle it, this being prepending
WINDOW to the result types in \df.
Another way, patch coming tomorrow, would be to add a \dw and remove
the functions where pg_proc.iswindowing is true from \df.
Cheers,
David.
--
David Fetter <da...@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
*** describe.c.orig 2009-04-06 19:47:44.000000000 -0700
--- describe.c 2009-04-06 20:02:25.000000000 -0700
***************
*** 202,207 ****
--- 202,208 ----
if (pset.sversion >= 80400)
appendPQExpBuffer(&buf,
+ " CASE WHEN p.proiswindow
THEN 'WINDOW ' END ||\n"
"
pg_catalog.pg_get_function_result(p.oid) as \"%s\",\n"
"
pg_catalog.pg_get_function_arguments(p.oid) as \"%s\"",
gettext_noop("Result data
type"),
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
