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

Bruce Momjian wrote:

>
> > Does anybody know how to use UNION and LIMIT together ?
> > I want to get 10 rows from publications and 10 rows
> > from keys.
> >
> > select msg_id from publications limit 10 union
> > select key_id from keys         limit 10
> > produces
> > ERROR:  parser: parse error at or near "union
> >
> > select msg_id from publications union
> > select key_id from keys         limit 10
> > produces something I wasn't expected
>
> I have on the TODO list:
>
>    * UNION with LIMIT fails

    and must fail by it's implementation. LIMIT is handled by the
    outermost executor loop, suppressing OFFSET result tuples and
    stopping execution after LIMIT results sent to the client.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#========================================= wieck@debis.com (Jan Wieck) #