Re: union all bug? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: union all bug?
Date
Msg-id 8621.1150649889@sss.pgh.pa.us
Whole thread Raw
In response to Re: union all bug?  ("Gurjeet Singh" <singh.gurjeet@gmail.com>)
List pgsql-hackers
"Gurjeet Singh" <singh.gurjeet@gmail.com> writes:
> Probably this explains the ERROR for the last query... The ORDER BY
> and LIMIT clauses are expected to end a query (except for subqueries,
> of course), and hence the keyword UNION is not expected after the
> LIMIT clause...

Yeah.  In theory that's unambiguous, but IIRC we couldn't persuade
bison of the fact, so you have to add parens.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Gurjeet Singh"
Date:
Subject: Re: union all bug?
Next
From: Greg Stark
Date:
Subject: Re: Rethinking stats communication mechanisms