Robert, > As between the two, I get the feeling that there is more interest in > writeable CTEs. But that impression might be wrong, since it's an > unscientific recollection of discussions on -hackers; which are > themselves not representative of anything.
Writeable CTE is definitely the bigger feature. Effectively, it allows people to do in a single query data-transformation operations which would have taken a stored procedure before. Think of it as comparable to the introduction of callbacks in Perl for coolness. > I have not looked at the window functions patch at all, and I haven't > looked at the latest version of writeable CTEs, either. I will try to > spend some time on it in the next couple of days. My feeling about > the last version is that it lacked a lot in the documentation > department, and also in the comments department. Since I don't know > that code very well, that made it hard for me to assess technical > correctness. Hmmm, that's potentially lethal. David Fetter has been doing a lot of presentations on the feature; surely he could turn them into some documentation? David? --Josh Berkus -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers