Re: [HACKERS] union and LIMIT problem - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] union and LIMIT problem
Date
Msg-id 199911300241.VAA22646@candle.pha.pa.us
Whole thread Raw
In response to Re: [HACKERS] union and LIMIT problem  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Can I assume this is fixed?  I see it marked on the TODO list.
> 
> Yes, I think it is (barring a counterexample from someone ... the
> UNION rewriter is awfully crufty ...).
> 
> It might be nice to allow LIMIT to be attached to subselects rather
> than just the top level, but I have no idea what it would take in the
> executor to implement that.  I could handle fixing the parser & planner
> if someone else wants to fix it in the executor.

Let's wait for someone to ask for it.

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] IN clause and INTERSECT not behaving as expected
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Arrays broken on temp tables