Search before asking

• I had searched in the issues and found no similar issues.

Description

We are going to support all regression functions in pg. You can see them in https://www.postgresql.org/docs/16/functions-aggregate.html with regr_ prefix. And considring the difficulty of this task, it will be nice for community as "good first issue".

In this issue, you should implement function regr_avgx, regr_avgy and regr_count

If you'd like to work on it, please comment to let me know. I'll help you to achieve this.

Solution

you can found an example of implementation of a aggregate function here

for regr_avgx and regr_avgy, you could only impl the FE function signature, and add a rule in ExpressionOptimization.java to rewrite them to avg() function because it has equivalent form of it. you can see ArrayContainToArrayOverlap rule to learn to write your own.

for regr_count you should completely impl it execution logic.

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct