Re: Final Patch for GROUPING SETS
От
Andrew Gierth
Тема
Re: Final Patch for GROUPING SETS
Дата
Msg-id
87iolhkvsq.fsf@news-spur.riddles.org.uk
Ответ на
WIP Patch for GROUPING SETS phase 1 (Atri Sharma)
Список
Дерево обсуждения
WIP Patch for GROUPING SETS phase 1 Atri Sharma <atri.jiit@gmail.com>
Re: Final Patch for GROUPING SETS Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: Final Patch for GROUPING SETS Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: Final Patch for GROUPING SETS Pavel Stehule <pavel.stehule@gmail.com>
Re: Final Patch for GROUPING SETS Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: Final Patch for GROUPING SETS Pavel Stehule <pavel.stehule@gmail.com>
Re: Final Patch for GROUPING SETS - unrecognized node
type: 347 "Erik Rijkers" <er@xs4all.nl>
Re: Final Patch for GROUPING SETS - unrecognized node
type: 347 Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: Final Patch for GROUPING SETS - unrecognized node
type: 347 Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: Final Patch for GROUPING SETS - unrecognized node
type: 347 "Erik Rijkers" <er@xs4all.nl>
Re: Final Patch for GROUPING SETS - unrecognized node
type: 347 Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: Final Patch for GROUPING SETS - unrecognized node
type: 347 "Erik Rijkers" <er@xs4all.nl>
Re: Final Patch for GROUPING SETS - unrecognized node
type: 347 "Erik Rijkers" <er@xs4all.nl>
Re: Final Patch for GROUPING SETS - unrecognized node type: 347 Atri Sharma <atri.jiit@gmail.com>
Re: Final Patch for GROUPING SETS - unrecognized node
type: 347 Andres Freund <andres@2ndquadrant.com>
Re: Final Patch for GROUPING SETS - unrecognized node type: 347 Atri Sharma <atri.jiit@gmail.com>
Re: Final Patch for GROUPING SETS - unrecognized node
type: 347 Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: Final Patch for GROUPING SETS - unrecognized node type:
347 Tomas Vondra <tv@fuzzy.cz>
Re: Final Patch for GROUPING SETS - unrecognized node
type: 347 Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: Final Patch for GROUPING SETS - unrecognized node type:
347 Tomas Vondra <tv@fuzzy.cz>
Re: Final Patch for GROUPING SETS - unrecognized node
type: 347 Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: Final Patch for GROUPING SETS - unrecognized node type:
347 Tomas Vondra <tv@fuzzy.cz>
Re: Final Patch for GROUPING SETS - unrecognized node
type: 347 Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: Final Patch for GROUPING SETS - unrecognized node type:
347 Tomas Vondra <tv@fuzzy.cz>
Re: Final Patch for GROUPING SETS - unrecognized node
type: 347 Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: Final Patch for GROUPING SETS Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: Final Patch for GROUPING SETS Marti Raudsepp <marti@juffo.org>
Re: Final Patch for GROUPING SETS Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: Final Patch for GROUPING SETS Marti Raudsepp <marti@juffo.org>
Re: Final Patch for GROUPING SETS Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: Final Patch for GROUPING SETS Andres Freund <andres@2ndquadrant.com>
Re: Final Patch for GROUPING SETS Petr Jelinek <petr@2ndquadrant.com>
Re: Final Patch for GROUPING SETS Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: WIP Patch for GROUPING SETS phase 1 Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: WIP Patch for GROUPING SETS phase 1 Heikki Linnakangas <hlinnakangas@vmware.com>
Re: WIP Patch for GROUPING SETS phase 1 Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: WIP Patch for GROUPING SETS phase 1 Robert Haas <robertmhaas@gmail.com>
Re: WIP Patch for GROUPING SETS phase 1 Pavel Stehule <pavel.stehule@gmail.com>
Re: WIP Patch for GROUPING SETS phase 1 Robert Haas <robertmhaas@gmail.com>
Re: WIP Patch for GROUPING SETS phase 1 Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: WIP Patch for GROUPING SETS phase 1 Robert Haas <robertmhaas@gmail.com>
Re: WIP Patch for GROUPING SETS phase 1 Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP Patch for GROUPING SETS phase 1 Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: WIP Patch for GROUPING SETS phase 1 Atri Sharma <atri.jiit@gmail.com>
Re: WIP Patch for GROUPING SETS phase 1 Heikki Linnakangas <hlinnakangas@vmware.com>
Re: WIP Patch for GROUPING SETS phase 1 Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: WIP Patch for GROUPING SETS phase 1 Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP Patch for GROUPING SETS phase 1 Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: WIP Patch for GROUPING SETS phase 1 Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP Patch for GROUPING SETS phase 1 Robert Haas <robertmhaas@gmail.com>
Re: WIP Patch for GROUPING SETS phase 1 Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP Patch for GROUPING SETS phase 1 Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: WIP Patch for GROUPING SETS phase 1 Robert Haas <robertmhaas@gmail.com>
Re: WIP Patch for GROUPING SETS phase 1 Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: WIP Patch for GROUPING SETS phase 1 Robert Haas <robertmhaas@gmail.com>
Re: WIP Patch for GROUPING SETS phase 1 Merlin Moncure <mmoncure@gmail.com>
Re: WIP Patch for GROUPING SETS phase 1 Greg Stark <stark@mit.edu>
Re: WIP Patch for GROUPING SETS phase 1 Andrew Dunstan <andrew@dunslane.net>
Re: WIP Patch for GROUPING SETS phase 1 Stephen Frost <sfrost@snowman.net>
Re: WIP Patch for GROUPING SETS phase 1 Greg Stark <stark@mit.edu>
Re: WIP Patch for GROUPING SETS phase 1 Stephen Frost <sfrost@snowman.net>
Re: WIP Patch for GROUPING SETS phase 1 Merlin Moncure <mmoncure@gmail.com>
Re: WIP Patch for GROUPING SETS phase 1 Andrew Dunstan <andrew@dunslane.net>
Re: WIP Patch for GROUPING SETS phase 1 Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP Patch for GROUPING SETS phase 1 Stephen Frost <sfrost@snowman.net>
Re: WIP Patch for GROUPING SETS phase 1 David Fetter <david@fetter.org>
Re: WIP Patch for GROUPING SETS phase 1 Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: WIP Patch for GROUPING SETS phase 1 Stephen Frost <sfrost@snowman.net>
Re: WIP Patch for GROUPING SETS phase 1 Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: WIP Patch for GROUPING SETS phase 1 Alvaro Herrera <alvherre@2ndquadrant.com>
Re: WIP Patch for GROUPING SETS phase 1 Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: WIP Patch for GROUPING SETS phase 1 Pavel Stehule <pavel.stehule@gmail.com>
Re: WIP Patch for GROUPING SETS phase 1 Pavel Stehule <pavel.stehule@gmail.com>
Here is the new version of our grouping sets patch. This version
supersedes the previous post.
We believe the functionality of this version to be substantially
complete, providing all the standard grouping set features except T434
(GROUP BY DISTINCT). (Additional tweaks, such as extra variants on
GROUPING(), could be added for compatibility with other databases.)
Since the debate regarding reserved keywords has not produced any
useful answer, the main patch here makes CUBE and ROLLUP into
col_name_reserved keywords, but a separate small patch is attached to
make them unreserved_keywords instead.
So there are now 5 files:
gsp1.patch - phase 1 code patch (full syntax, limited functionality)
gsp2.patch - phase 2 code patch (adds full functionality using the
new chained aggregate mechanism)
gsp-doc.patch - docs
gsp-contrib.patch - quote "cube" in contrib/cube and contrib/earthdistance,
intended primarily for testing pending a decision on
renaming contrib/cube or unreserving keywords
gsp-u.patch - proposed method to unreserve CUBE and ROLLUP
--
Andrew (irc:RhodiumToad)
В списке pgsql-hackers по дате отправления
От: Guillaume Lelarge
Дата: