On Mon, Dec 27, 2010 at 09:51:01PM -0500, Robert Haas wrote: > On Mon, Dec 27, 2010 at 9:28 PM, David Fetter <da...@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 <da...@fetter.org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers