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(at)fetter(dot)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(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)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