On Wed, Oct 8, 2008 at 4:31 PM, Richard Broersma <richard(dot)broersma(at)gmail(dot)com
> 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/