David Fetter escribió:
> On Thu, Jun 20, 2013 at 08:59:27PM +0100, Dean Rasheed wrote:
> > In my testing of sub-queries in the FILTER clause (an extension to the
> > spec), I was able to produce the following error:
>
> Per the spec,
>
> B) A <filter clause> shall not contain a <query expression>, a <window function>, or an outer reference.
If this is not allowed, I think there should be a clearer error message.
What Dean showed is an internal (not user-facing) error message.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services