New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
No equivalent to LEAST and GREATEST in SQL ? #4151
Comments
What would be a nicer way to do this than
|
Yes we should probably add these functions. Using s-strings is the best approach for the moment. For adding them — do we want to use We could instead use |
I would probably keep least and greatest for consistency, or perhaps just have an "overload" of min which can be used when there are multiple params, eg |
What's up?
I have a table where each row has for example
temperature_a, temperature_b, etc
and I want to create a condition if min(temperature_a, temperature_b) < somethreshold OR max(temperature_a, temperature_b) > someOtherThreshold
in SQL I can do something like
but I don't see the equivalent in PRQL?
The text was updated successfully, but these errors were encountered: