Re: Closing some 8.4 open items

On Sat, Apr 11, 2009 at 03:48:33PM +0900, Hitoshi Harada wrote:
> 2009/4/11 Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>:
> >>>>>> "Tom" == Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
> >
> >  >>> Perhaps more to the point: the previous round of discussion about
> >  >>> this already rejected the idea of treating window functions as a
> >  >>> category fundamentally separate from plain functions --- that is,
> >  >>> we are not following the "aggregate" model of having separate
> >  >>> commands for aggregate functions.
> >
> >  >> I hadn't seen any such a consensus.
> >
> >  Tom> We do not have CREATE WINDOW FUNCTION, DROP WINDOW FUNCTION,
> >  Tom> ALTER WINDOW FUNCTION, etc.  If psql uses \dw it will be
> >  Tom> presenting a different world view than exists at the SQL level.
> >
> > I'm not sure why that would matter. The fact that it is CREATE
> > FUNCTION ... WINDOW rather than CREATE WINDOW FUNCTION doesn't mean
> > that window functions aren't a distinctly different animal to normal
> > functions. The usage and syntax is different enough that putting them
> > all together under \df seems forced.
>
> 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 :)

Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate