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 <[EMAIL PROTECTED]> 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
