Re: Suspected bug: outer WHERE reordered before inner WHERE -> input syntax ERROR

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: John Keith Hohm <john(at)hohm(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Suspected bug: outer WHERE reordered before inner WHERE -> input syntax ERROR
Date: 2008-09-08 19:48:29
Message-ID: 4277.1220903309@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

John Keith Hohm <john(at)hohm(dot)net> writes:
> Thanks for telling me about LIMIT ALL being an optimization fence.
> I believe you that it is not a bug, but I admin I cannot find any
> documentation of that entitlement.

It's over here:
http://www.postgresql.org/docs/8.3/static/sql-expressions.html#SYNTAX-EXPRESS-EVAL

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message William Garrison 2008-09-08 22:18:41 Install Postgres on a SAN volume?
Previous Message Tom Lane 2008-09-08 19:46:39 Re: Suspected bug: outer WHERE reordered before inner WHERE -> input syntax ERROR