honeysql 2022-09-14 | Slack Archive

mattly21:09:05

does anyone know if there’s been much prior art for helpers on the frame clause of a postgresql window function? I’m talking about the part such as ROWS BETWEN UNBOUNDED PRECEDING AND 1 FOLLOWING EXCLUDING CURRENT ROW

seancorfield22:09:17

I don't know of anything. I don't know how much folks are using HoneySQL for window stuff at all right now...

mattly22:09:44

thanks;

mattly22:09:13

I’ve been using honeysql a lot as part of prototyping out a larger query engine, it’s been great for that

mattly22:09:19

I may have to blaze this trail

seancorfield22:09:23

I'm happy to add support into the core if you create a GH issue with details of the syntax in context and a link to the PG docs for it.

👍 1

2022-09-14

Channels