Re: Parsing ambiguity for ORDER BY ... NULLS FIRST/LAST - Mailing list pgsql-hackers

On Sat, 2007-01-06 at 13:05 -0500, Tom Lane wrote:
> "Simon Riggs" <simon@2ndquadrant.com> writes:
> > Presumably you could put extra grammar rules in to throw errors when you
> > see FROM NULLS FIRST?
> 
> It'll throw an error just fine without any extra rules, because there
> won't be any production allowing the NULLS_FIRST pseudo-token there.
> You already see this in 8.2:
> 
> regression=# select * from with cascaded;
> ERROR:  syntax error at or near "cascaded"
> LINE 1: select * from with cascaded;
>                            ^

OK, Sounds good.

--  Simon Riggs              EnterpriseDB   http://www.enterprisedb.com