Replies: 1 comment
-
|
+1 |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
PostgreSQL and data.world (and others) have some very interesting boolean aggregation functions, BOOL_AND and BOOL_OR, which aggregate columns (here properties) based on a boolean expression (optionally into groups). While one can probably emulate these function with nested queries and
counts, the appeal of these function would be their performant short-circuit implementation, meaningANDreturnsfalseas soon as the firstfalse(in a group) is found, andORreturnstrueas soon as the firsttrue(in a group) is found.I would like to propose adding these two boolean aggregators, as they should be really useful for data cleaning or data exploration, answering questions like "Are all of ..." or "Are any of ..." fast. Thus, they also fit well with the Play With Data motto. Lastly, these functions are different to filtering with
all()andany()due to different scope (property vs document) and are (only in purpose) similar to SQL'sALLandANY.Thank you for considering my proposal
Beta Was this translation helpful? Give feedback.
All reactions