Re: Understanding 8.4 new WITH syntax

["Grzegorz Jaśkiewicz" <gryzman@xxxxxxxxx>]

On Wed, Oct 8, 2008 at 4:31 PM, Richard Broersma <richard.broersma@xxxxxxxxx> wrote:

I've seen a few examples about 8.4 Implementation of WITH syntax.

However, I don't fully understand how the various parts of this kind
of query work together as a whole.  Does anyone know of any good
resources that explain it well?

 http://developer.postgresql.org/pgdocs/postgres/queries-with.html 

  is the way to go. 

Try writing some stuff, to understand it. Otherwise you can read as much as you wish. 

Also, you can try to read our colleague's blog:

   http://www.depesz.com/index.php/2008/10/07/waiting-for-84-common-table-expressions-with-queries/