Conversation

Today's discovery: apparently it's possible to specify 'distinct' inside aggregates in PostgreSQL.

Replying to

@alexeyklyukin pretty sure that's standard SQL. Whereas the ORDER BY inside aggregate is PostgreSQL specific.

Replying to

@alexeyklyukin "select distinct" is standard SQL. "select distinct on" is Postgres-ism.

Replying to

@alexeyklyukin It's about SELECT count(distinct col)), though.

Replying to

@alexeyklyukin Ah, yes. Jumped the gun.

Replying to

@alexeyklyukin yes, I (we?) know those. But we're talking about inside aggregates, e.g. SELECT foo,count(distinct bar) FROM ...