David Fetter <[EMAIL PROTECTED]> writes:
> On Tue, Jun 19, 2007 at 07:36:02PM -0400, Tom Lane wrote:
>> Since there's no "(array) ANY op scalar" syntax,
> Why isn't there? Is it forbidden by the SQL standard?
Well, the spec has
<quantified comparison predicate> ::=
<row value expression> <comp op> <quantifier>
<table subquery>
<quantifier> ::= <all> | <some>
<all> ::= ALL
<some> ::= SOME | ANY
and not the reverse. The array syntax is an abuse of this notation
and doesn't have the reverse either. I'm not really sure how much
new code would be needed to support the other case, or whether it
would be worth the trouble.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
