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/ ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
