Re: A rare error - Mailing list pgsql-general

From Stephan Szabo
Subject Re: A rare error
Date
Msg-id Pine.BSF.4.10.10010250853220.21171-100000@megazone23.bigpanda.com
Whole thread Raw
In response to A rare error  (DaVinci <bombadil@wanadoo.es>)
List pgsql-general
Looks like it probably is.  The spec production
seems to allow query expressions to contain
()ized non-join query expressions or
()ized joined tables.

Stephan Szabo
sszabo@bigpanda.com

On Wed, 25 Oct 2000, DaVinci wrote:

> Hi, all.
>
> An extrange behavior with PostgreSql 7.0.2:
>
>     select * from foo where exists
>     (select * from foo)
>
> works fine. But:
>
>     select * from foo where exists
>     ((select * from foo))
>
> shows an error:
>
>     ERROR: parser: parse error at or near "("
>
> Is this a bug?
>
> Thanks.
>
>                     David
>


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problems with genetic optimizer
Next
From: Tom Lane
Date:
Subject: Re: A rare error