Re: ALL, ANY bug?

You are right. However, SQL92 spec allows:

select * from t1 where i <> all values(0,1);

which is not allowed in PostgreSQL...
--
Tatsuo Ishii

> 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