]> granicus.if.org Git - postgresql/commit
Add a WINDOW attribute to CREATE FUNCTION, and teach pg_dump about it,
authorTom Lane <tgl@sss.pgh.pa.us>
Wed, 31 Dec 2008 02:25:06 +0000 (02:25 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Wed, 31 Dec 2008 02:25:06 +0000 (02:25 +0000)
commit26ce4e85a1605326f29e3cb0cc715ddf522a753a
treebfd2ca91df26e9aff0873e0c59ce20d3ae096621
parent8e8854daa2b4b3ef9e3fc1a56c79608a70018058
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.
doc/src/sgml/ref/create_function.sgml
src/backend/catalog/pg_aggregate.c
src/backend/catalog/pg_proc.c
src/backend/commands/functioncmds.c
src/backend/commands/proclang.c
src/backend/parser/gram.y
src/backend/utils/adt/ruleutils.c
src/bin/pg_dump/pg_dump.c
src/include/catalog/pg_proc_fn.h