Re: "writable CTEs"

On Mon, Dec 27, 2010 at 09:51:01PM -0500, Robert Haas wrote:
> On Mon, Dec 27, 2010 at 9:28 PM, David Fetter <david@fetter.org> wrote:
> > On Tue, Dec 28, 2010 at 12:19:47AM +0000, Peter Geoghegan wrote:
> >> It's worth noting that officially (i.e. in the docs), we don't even
> >> call CTEs CTEs at any point. We call them WITH queries. I think that
> >> that's a mistake because we call them CTEs everywhere else.
> >
> > Agreed.
> >
> >> Is there interest in correcting this, by putting "CTEs" or "Common
> >> table expressions" in parenthesis after "WITH queries" in the docs
> >> at certain select places? I could write a documentation patch.
> >
> > +1 :)
> 
> Would it make sense to work a section into the documentation
> explaining the semantics of CTEs?  e.g., evaluate-once.

Yep.  It should probably go where "WITH Queries" is now, i.e.
   http://www.postgresql.org/docs/current/static/queries-with.html

would become (doesn't exist yet):
   http://www.postgresql.org/docs/current/static/queries-common-table-expression.html

Cheers,
David.
-- 
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate