Hello All! I am looking for documentation that confirms that WITH *
is a supported construct
I can’t find it on:
...but it came up in an example on Slack a few days ago, and it seems to work?
Hello All! I am looking for documentation that confirms that WITH *
is a supported construct
I can’t find it on:
...but it came up in an example on Slack a few days ago, and it seems to work?
Yes it is legit and quite useful if you don't want to repeat yourself time and again
Same for return *
Just be aware that if you're calling an aggregation function in your WITH clause, it's best to be explicit unless you're sure WITH *
is correct, since the other variables in scope give context to the aggregation and form the grouping key.
Finally found it documented under RETURN *
and mentally extrapolated to WITH *
Thanks for the tips, all.