Re: ALL, ANY bug? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: ALL, ANY bug?
Date
Msg-id 4735.978923186@sss.pgh.pa.us
Whole thread Raw
In response to ALL, ANY bug?  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Responses Re: ALL, ANY bug?
List pgsql-hackers
Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> It seems ALL and ANY (SOME) have problems with the parser.

I see no problem here.  Those are only defined for sub-selects.
SQL92 8.7 says:
        <quantified comparison predicate> ::=             <row value constructor> <comp op> <quantifier> <table
subquery>
        <quantifier> ::= <all> | <some>
        <all> ::= ALL
        <some> ::= SOME | ANY

and that is the only appearance of ANY in the grammar ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Marko Kreen
Date:
Subject: Re: patch: contrib/pgcrypto sanity
Next
From: Denis Perchine
Date:
Subject: Re: Quite strange crash