>>>>> "Tom" == Tom Lane <t...@sss.pgh.pa.us> writes:
Tom> What I'm now thinking we want to do is: Tom> 1. Non-hypothetical direct args always contribute to determining Tom> the agg's collation. Tom> 2. Hypothetical and aggregated args contribute to the agg's Tom> collation only if the agg is designed so that there is always Tom> exactly one aggregated arg (ie, it's non-variadic with one Tom> aggregated arg). Otherwise we assign their collations Tom> per-sort-column and don't merge them into the aggregate's Tom> collation. Tom> This specification ensures that a variadic aggregate doesn't Tom> change behavior depending on how many sort columns there happen Tom> to be. Works for me. -- Andrew (irc:RhodiumToad) -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers