On Monday, July 3, 2023, hape Hape <
postgres-hape@gmx.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.