Re: pg ANY/SOME ambiguity wrt sql standard? - Mailing list pgsql-hackers

From Fabien COELHO
Subject Re: pg ANY/SOME ambiguity wrt sql standard?
Date
Msg-id Pine.GSO.4.58.0405011127240.6700@chailly99
Whole thread Raw
In response to Re: pg ANY/SOME ambiguity wrt sql standard?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg ANY/SOME ambiguity wrt sql standard?
List pgsql-hackers
> > As a "temporary" fix, what about "_ANY" and "_SOME" as aggregate names?
>
> Ick :-(.  The use of leading underscores is an ugly C-ism that we should
> not propagate into SQL names.

Ok.

> How about bool_or() and bool_and()?  Or at least something based on OR
> and AND?  I don't find ANY/ALL to be particularly mnemonic for this
> usage anyway.

Yep.

The standard "EVERY" is fine for postgres, the issue is only with
ANY/SOME.

Do you think that bool_and should be proposed anyway for homogeneity
with bool_or?

-- 
Fabien Coelho - coelho@cri.ensmp.fr


pgsql-hackers by date:

Previous
From: reina_ga@hotmail.com (Tony Reina)
Date:
Subject: Re: New COPY commands in libpq
Next
From: reina_ga@hotmail.com (Tony Reina)
Date:
Subject: Re: New COPY commands in libpq