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