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

> 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


--  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