Re: WITHIN GROUP patch - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: WITHIN GROUP patch
Date
Msg-id CAFj8pRA=-RDzVFN8nzR0F+u5HmiMHksk9J1HdnVmETCPVEn=yQ@mail.gmail.com
Whole thread Raw
In response to Re: WITHIN GROUP patch  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
List pgsql-hackers



2013/10/11 Andrew Gierth <andrew@tao11.riddles.org.uk>
>>>>> "Pavel" == Pavel Stehule <pavel.stehule@gmail.com> writes:

 >> I found so following error message is not too friendly (mainly because
 >> this functionality will be new)
 >>
 >> postgres=# select dense_rank(3,3,2) within group (order by num desc, odd)
 >> from test4;
 >> ERROR:  Incorrect number of arguments for hypothetical set function
 >> LINE 1: select dense_rank(3,3,2) within group (order by num desc, od...
 >> ^
 >>
 >> Probably some hint should be there?

Hm, yeah.

Anyone have ideas for better wording for the original error message,
or a DETAIL or HINT addition? The key point here is that the number of
_hypothetical_ arguments and the number of ordered columns must match,
but we don't currently exclude the possibility that a user-defined
hypothetical set function might have additional non-hypothetical args.

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)

+1

Pavel
--
Andrew (irc:RhodiumToad)

pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Auto-tuning work_mem and maintenance_work_mem
Next
From: Haribabu kommi
Date:
Subject: Re: Compression of full-page-writes