On Sat, Jun 16, 2012 at 2:52 PM, Tom Lane <t...@sss.pgh.pa.us> wrote:
> Magnus Hagander <mag...@hagander.net> writes:
>> Basically, I'd like to combine a recursive and a non-recursive CTE in
>> the same query.
> Just mark them all as recursive.  There's no harm in marking a CTE as
> recursive when it isn't really.

Hah. I could've sworn I tried that and got the typical error of "you
need to use the union construct for recursive queries". But clearly I
must've typoed something in that one, because when I did that over
again, it now worked perfectly...


 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:

Reply via email to