Re: BUG #14974: count doesn't accept text columns

Correct.
Thank you.
Regards
Jarek

14.12.2017 13:47 "Marko Tiikkaja" <marko(at)joh(dot)to> napisał(a):

> On Thu, Dec 14, 2017 at 2:33 PM, <jarek(dot)stoklosa(at)gmail(dot)com> wrote:
>
>> The following bug has been logged on the website:
>>
>> Bug reference: 14974
>> Logged by: Jarosław Stokłosa
>> Email address: jarek(dot)stoklosa(at)gmail(dot)com
>> PostgreSQL version: 9.6.6
>> Operating system: Linux
>> Description:
>>
>> create table test (t TEXT, tt TEXT);
>> insert into test values('a', 'b');
>> insert into test values('a', null::TEXT);
>> select t, count(tt) from test group by t;
>>
>> Should be (a, 1) but I've got a error message:
>> column "test.tt" must appear in the GROUP BY clause or be used in an
>> aggregate function
>>
>
> Works just fine here.
>
>
>> select t, count(distinct tt) from test group by t;
>> gives "DISTINCT specified, but count is not an aggregate function"
>>
>
> Are you sure you don't have a poorly-named "count" function defined?
> What's the output of:
>
> \df *.count
>
> from psql?
>
>
> .m
>