Re: group by can use alias from select list but not the having clause

On Monday, July 3, 2023, hape Hape <postgres-hape(at)gmx(dot)de> wrote:

>
> a) the group by also doesn't know about otto
>
>
>
The isn’t a bug as we explicitly document our deviation from the standard
for group by. You are correct that you are better off not using output
column aliases in the group by specification. But we are not going to make
doing so,an error and break countless applications relying upon the
documented behavior. But we are also not going to double-down and allow
the undesirable deviation for having.

David J.