parse error: LIMIT combined with UNION

============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name        :    Steve Pothier
Your email address    :    pothiers@aries.tucson.saic.com


System Configuration
---------------------
  Architecture (example: Intel Pentium)      : Mac PPC, G4

  Operating System (example: Linux 2.0.26 ELF)     : Linux payson 2.2.16

  PostgreSQL version (example: PostgreSQL-6.5.1):   PosegreSQL 7.1

  Compiler used (example:  gcc 2.8.0)        :


Please enter a FULL description of your problem:
------------------------------------------------

This works as expected:

hbase=# SELECT * FROM subject WHERE subject_id LIKE '0009%' UNION (SELECT * FROM subject WHERE subject_id LIKE '0008%'
);


But this fails to parse:

hbase=# SELECT * FROM subject WHERE subject_id LIKE '0009%' UNION (SELECT * FROM subject WHERE subject_id LIKE '0008%'
LIMIT5); 
ERROR:  parser: parse error at or near "limit"

This, despite indications to the contrary in the documentation:
   file:/swl/postgresql-7.1/doc/html/sql-select.html#SQL-UNION

The following excerpt from the doc seems to be saying that a limit can
be used if included in the parenthesized select statement:

"where table_query specifies any select expression without an ORDER BY, FOR UPDATE, or
LIMIT clause. (ORDER BY and LIMIT can be attached to a sub-expression if it is enclosed in
parentheses. Without parentheses, these clauses will be taken to apply to the result of the UNION,
not to its right-hand input expression.) "


I tried several moving the parens around to no avail.

-Steve Pothier-
----------------------------------------------------------------------





If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------