Re: parse error: LIMIT combined with UNION

Steve Pothier <STEVEN.POTHIER@saic.com> writes:
>   PostgreSQL version (example: PostgreSQL-6.5.1):   PosegreSQL 7.1

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

Are you sure that's actually 7.1, and not some beta release?  The
command parses fine for me in current sources and in 7.1.3.  AFAICT,
the last time anyone changed LIMIT/sub-SELECT parsing was 2001-01-15,
which would have been post 7.1-beta3.

            regards, tom lane