Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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: Wed, 31 Dec 2008 02:25:06 +0000 (UTC)
  • Message-id: <20081231022506.5A545754A03@cvs.postgresql.org> <text/plain>

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)



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group