Steve Pothier <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
