4 ms·
one is counting distance, the other one buckets. alias the fn name to datebucketdelta to make the different problems memorable individually. :)
by michael-ax 5y ago
one is counting distance, the other one buckets.
alias the fn name to datebucketdelta to make the different problems memorable individually. :)
- castorp 5y agoWell for "counting buckets" you can use `date_bin()` since Postgres 14 which groups the difference between timestamps into defined intervals.