4 ms·
The next thing I would like is to define a function / macro that has a bunch of |> terms. I pointed out that you can do this with shell: Pipelines Support Vec
by chubot 2y ago
The next thing I would like is to define a function / macro that has a bunch of |> terms.
I pointed out that you can do this with shell:
Pipelines Support Vectorized, Point-Free, and Imperative Style https://www.oilshell.org/blog/2017/01/15.html https://www.oilshell.org/blog/2017/01/15.html
e.g.
hist() {
sort | uniq -c | sort -n -r
}
$ { echo a; echo bb; echo a; } | hist
1 bb
2 a
$ foo | hist
...
Something like that should be possible in SQL!
- jshute4444 2y agoIt is, using table-valued functions (TVFs). There's an example at the bottom of this file: https://github.com/google/zetasql/blob/master/zetasql/examples/pipe_queries/walkthrough_7day.sql https://github.com/google/zetasql/blob/master/zetasql/exampl...
- chubot 2y agoThat's cool, thanks! What about scalar valued functions? :) So I can reuse an expression in a WHERE and so forth (and I appreciate that HAVING can be generalized/removed)