On Sat, Apr 11, 2009 at 08:52:31AM -0400, Robert Haas wrote:
> On Sat, Apr 11, 2009 at 5:06 AM, Grzegorz Jaskiewicz
> <gj@pointblue.com.pl> wrote:
> > On 11 Apr 2009, at 08:01, Hitoshi Harada wrote:
> >> 2009/4/11 David Fetter <david@fetter.org>:
> >>> On Sat, Apr 11, 2009 at 03:48:33PM +0900, Hitoshi Harada wrote:
> >>>> Yeah, but all the window functions are stored in pg_proc.
> >>> So are aggregate functions, and they have their own separate way of
> >>> being addressed in psql :)
> >> Aggregate functions are stored in pg_aggregate. And they are
> >> combinations of plain function which is stored in pg_proc.
> > Maybe trigger functions should be displayed separately too than ?
>
> We're up to at least four different categories of functions that
> people think might require special treatment: window, trigger, I/O,
> everything else.
The current psql has \da and \df, the latter of which now includes I/O
functions. I contend that windowing functions are different enough
that they require a separate category.
You do bring up an interesting point for 8.5 or later, which would be
a complete redo of psql from the ground up. Let's hash out a proposal
for that in a separate thread once we get 8.4 out the door :)
Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fetter@gmail.com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate