Re: [BUGS] parse error: LIMIT combined with UNION

2001-09-10 Thread Steve Pothier
Tom, You are correct. My humblest apologies. When I did the test it was on a machine not local to the database. The client machine was running psql 7.1 but the server is (apparently) 7.0.3. I say "apparently" because I'm not sure how to find the version of the server! I just assume that the

Re: [BUGS] parse error: LIMIT combined with UNION

2001-09-07 Thread Tom Lane
Steve Pothier <[EMAIL PROTECTED]> writes: > psql 7.1 but the server is (apparently) 7.0.3. I say "apparently" > because I'm not sure how to find the version of the server! select version(); regards, tom lane ---(end of broadcast)-

Re: [BUGS] parse error: LIMIT combined with UNION

2001-09-06 Thread Tom Lane
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