Re: [HACKERS] GSets: Getting collation related error when GSets has text column

2015-07-26 Thread Andres Freund
Hi, On 2015-07-17 18:55:52 +0530, Jeevan Chalke wrote: > Attached patch which attempts to fix this issue. However I am not sure > whether it is correct. But it does not add any new issues as such. > Added few test in the patch as well. Pushed the fix. Thanks for the report and fix. - Andres --

Re: [HACKERS] GSets: Getting collation related error when GSets has text column

2015-07-17 Thread Andrew Gierth
> "Jeevan" == Jeevan Chalke writes: Jeevan> Hi, Jeevan> When we have text column in the GROUPING SETS (and with some specific Jeevan> order of columns), we are getting error saying Jeevan> "could not determine which collation to use for string comparison" Good catch. Jeevan> After spe

[HACKERS] GSets: Getting collation related error when GSets has text column

2015-07-17 Thread Jeevan Chalke
Hi, When we have text column in the GROUPING SETS (and with some specific order of columns), we are getting error saying "could not determine which collation to use for string comparison" Here is the example: postgres=# select sum(ten) from onek group by rollup(four::text), two order by 1; ERROR