Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: [HACKERS] LIMIT and UNION
Date
Msg-id 16150.931019086@sss.pgh.pa.us
Whole thread Raw
In response to LIMIT and UNION  (Chris Bitmead <chris@tech.com.au>)
List pgsql-hackers
Tree view 
Chris Bitmead <chris@tech.com.au> writes:
> Is it a known problem that LIMIT doesn't work with UNION, or have I
> discovered a bug?

Not sure, but I think the LIMIT would be parsed as an attribute of
one or the other of the sub-selects, not as a limit on the total
result size.  This is probably not the behavior you want :-(
        regards, tom lane

pgsql-hackers by date:

Previous
From: Michael Robinson
Date:
Subject: Re: [HACKERS] regression bigtest needs very long time
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] LIMIT and UNION