Re: ALL, ANY bug?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: ALL, ANY bug?
Date: 2001-01-08 03:06:26
Message-ID: 4735.978923186@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Denis Perchine 2001-01-08 06:40:46 Re: Quite strange crash
Previous Message Marko Kreen 2001-01-08 02:06:09 Re: patch: contrib/pgcrypto sanity