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... Thanks! -- 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: http://www.postgresql.org/mailpref/pgsql-hackers