Robert Hostetter wrote:
> If you group by a primary key for a table,
> you still have to include all the other columns you SELECT from that
> row, even though its guaranteed uniuqe because its a primary key.
Yes, this feature request is known as supporting functional
dependencies. We're aware of it.
> pAlso on a similar note, you can't group by any
> column you don't select.
Sure you can.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/