DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=DKIM-Signature:X-Yahoo-Newman-Property:X-YMail-OSG:X-Yahoo-SMTP:Received:References:Mime-Version:In-Reply-To:X-Apple-Yahoo-Original-Message-Folder:Content-Type:Content-Transfer-Encoding:Message-Id:Cc:X-Mailer:From:X-Apple-Yahoo-Replied-Msgid:Subject:Date:To;
	b=6ZGiwSZ1Y1IuKBuw0exS2KD7czNenz+M+gtB9KSvM5E88+QUY5PTu7OvyDqAImgHCSr6Ja9ObHIlDo9crRk+86NDcF39UQFbhGEL1uZ3t+qiQ94020SoVbqe8w/H2W0mf74FldSmnOwYSelWD2ze237dFySu4DatxTbZ91aqUJA=
	;
References: <j59o2m$dn1$1@dough.gmane.org>
Mime-Version: 1.0 (iPad Mail 8J2)
In-Reply-To: <j59o2m$dn1$1@dough.gmane.org>
Content-Type: multipart/alternative;
	boundary=Apple-Mail-5-1065970163
Content-Transfer-Encoding: 7bit
Message-Id: <1E5EC0E1-13DB-4346-B8EE-212F4DC4CCEA@yahoo.com>
Cc: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
From: David Johnston <polobo@yahoo.com>
Subject: Re: Combining several CTEs with a recursive CTE
Date: Tue, 20 Sep 2011 10:15:01 -0400
To: Thomas Kellerer <spam_eater@gmx.net>


--Apple-Mail-5-1065970163
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=us-ascii

On Sep 20, 2011, at 5:58, Thomas Kellerer <spam_eater@gmx.net> wrote:

>=20
> I'm just wondering if this is intended behavioury, simply not (yet) implem=
ented or even invalid according to the standard? I didn't find any reference=
 that it's not allowed in the manual.
>=20
> Regards
> Thomas
>=20
>=20

Try sticking the recursive keyword after the "with" if any of the following C=
TEs are recursive. =20

WITH RECURSIVE=20
normal1 AS ()
,recursine1 AS ()
,normal2 AS ()
,recursine2 AS ()
SELECT ...

David J.=

--Apple-Mail-5-1065970163
Content-Transfer-Encoding: 7bit
Content-Type: text/html;
	charset=utf-8

<html><body bgcolor="#FFFFFF"><div>On Sep 20, 2011, at 5:58, Thomas Kellerer &lt;<a href="mailto:spam_eater@gmx.net">spam_eater@gmx.net</a>&gt; wrote:<br><font class="Apple-style-span" color="#0023A3"><font class="Apple-style-span" color="#000000"><br></font></font></div><blockquote type="cite"><div><span></span><br><span>I'm just wondering if this is intended behavioury, simply not (yet) implemented or even invalid according to the standard? I didn't find any reference that it's not allowed in the manual.</span><br><span></span><br><span>Regards</span><br><span>Thomas</span><br><span></span><br><br></div></blockquote><br><div>Try sticking the recursive keyword after the "with" if any of the following CTEs are recursive. &nbsp;</div><div><br></div><div>WITH RECURSIVE&nbsp;</div><div>normal1 AS ()</div><div>,recursine1 AS ()</div><div>,normal2 AS ()</div><div>,recursine2 AS ()</div><div>SELECT ...</div><div><br></div><div>David J.</div></body></html>
--Apple-Mail-5-1065970163--