pgsql: Add a WINDOW attribute to CREATE FUNCTION, and teach pg_dump

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Add a WINDOW attribute to CREATE FUNCTION, and teach pg_dump
Date: 2008-12-31 02:25:06
Message-ID: 20081231022506.5A545754A03@cvs.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Add a WINDOW attribute to CREATE FUNCTION, and teach pg_dump about it,
so that user-defined window functions are possible. For the moment you'll
have to write them in C, for lack of any interface to the WindowObject API
in the available PLs, but it's better than no support at all.

There was some debate about the best syntax for this. I ended up choosing
the "it's an attribute" position --- the other approach will inevitably be
more work, and the likely market for user-defined window functions is
probably too small to justify it.

Modified Files:
--------------
pgsql/doc/src/sgml/ref:
create_function.sgml (r1.83 -> r1.84)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/create_function.sgml?r1=1.83&r2=1.84)
pgsql/src/backend/catalog:
pg_aggregate.c (r1.99 -> r1.100)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/pg_aggregate.c?r1=1.99&r2=1.100)
pg_proc.c (r1.158 -> r1.159)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/pg_proc.c?r1=1.158&r2=1.159)
pgsql/src/backend/commands:
functioncmds.c (r1.104 -> r1.105)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/functioncmds.c?r1=1.104&r2=1.105)
proclang.c (r1.82 -> r1.83)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/proclang.c?r1=1.82&r2=1.83)
pgsql/src/backend/parser:
gram.y (r2.649 -> r2.650)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/parser/gram.y?r1=2.649&r2=2.650)
pgsql/src/backend/utils/adt:
ruleutils.c (r1.292 -> r1.293)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/ruleutils.c?r1=1.292&r2=1.293)
pgsql/src/bin/pg_dump:
pg_dump.c (r1.509 -> r1.510)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/pg_dump.c?r1=1.509&r2=1.510)
pgsql/src/include/catalog:
pg_proc_fn.h (r1.4 -> r1.5)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_proc_fn.h?r1=1.4&r2=1.5)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2008-12-31 18:07:47 pgsql: Consistently use multi-line formatting for all ACL columns
Previous Message Tom Lane 2008-12-31 00:08:39 pgsql: Add some basic support for window frame clauses to the