Re: Combine non-recursive and recursive CTEs?

On Sat, Jun 16, 2012 at 2:52 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Magnus Hagander <magnus(at)hagander(dot)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...

Thanks!

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