Vitaly Belman <[EMAIL PROTECTED]> writes: > The problem is that addind them all to GROUP BY causes a performance > loss.
Really? I'd think that there'd be no visible loss if the earlier fields of the GROUP BY are already unique. The sort comparison should stop at the first field that determines the sort order. Can you provide a self-contained example? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: 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