Hacker News Reader

You can do that with standard aggregates by comparing min() and max().

Or sometimes you can do something like FIRST() OVER (ORDER BY NULL).

I don't think that errors if the group contains different values...?

In postgres you can array_agg(distinct) and error on the application side if there is more than one value.