On Thu, Oct 10, 2013 at 10:35 PM, Andrew Gierth <and...@tao11.riddles.org.uk> wrote: > The first alternative that springs to mind is: > > ERROR: Incorrect number of arguments for hypothetical set function > DETAIL: Number of hypothetical arguments (3) must equal number of ordered > columns (2)
I'd suggest trying to collapse that down into a single message; the DETAIL largely recapitulates the original error message. Also, I'd suggest identifying the name of the function, since people may not be able to identify that easily based just on the fact that it's a hypothetical set function. Here's one idea, with two variants depending on the direction of the inequality: ERROR: function "%s" has %d arguments but only %d ordering columns ERROR: function "%s" has %d ordering columns but only %d arguments Or else leave out the actual numbers and just state the principle, but identifying the exact function at fault, e.g. ERROR: number of arguments to function "%s" does not match number of ordering columns -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers