On Sat, Jun 16, 2012 at 2:52 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Magnus Hagander <magnus@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...
Thanks!
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/