search

kirschbaum-development / eloquent-power-joins

The Laravel magic you know, now applied to joins.
MIT License
1.39k stars 87 forks source link

Issue with HAVING clause in powerJoinHas on postgres. #153

Closed s-7777 closed 1 year ago

s-7777 commented 1 year ago

When using the powerJoinHas method, the generated SQL query uses an alias for the count in the HAVING clause. This results in an error in PostgreSQL, as it does not allow the use of aliases in the HAVING clause.