Re: select count(*); - Mailing list pgsql-general

From Marc Mamin
Subject Re: select count(*);
Date
Msg-id B6F6FD62F2624C4C9916AC0175D56D8828BE8045@jenmbs01.ad.intershop.net
Whole thread Raw
In response to Re: select count(*);  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general

> -----Original Message-----
> From: Adrian Klaver [mailto:adrian.klaver@aklaver.com]
> Sent: Donnerstag, 11. Juni 2015 16:31
> To: Marc Mamin; 'Geoff Winkless'; Postgres General
> Subject: Re: [GENERAL] select count(*);
> 
> On 06/11/2015 07:17 AM, Marc Mamin wrote:
> >>> That's the point. * has no meaning without FROM
> >
> >
> >> But COUNT(*)
> >>
> >> does have meaning - it means "the number of rows".
> >
> > which rows? :-)
> 
> To follow up on the post from Chris Mair:
> 
> test=> select count(*), 'foo';
>   count | ?column?
> -------+----------
>       1 | foo


Fine, This explains why the result must be 1 :)

Marc

> 
> See also:
> 
> http://www.postgresql.org/docs/9.4/interactive/functions-aggregate.html
> 
> 
> count(*)           bigint     number of input rows
> >
> >> It's not counting the number of columns in the row, so postgres
> doesn't need to know what columns exist in the row to return a row
> count.
> >
> >> Geoff
> >
> >
> 
> 
> --
> Adrian Klaver
> adrian.klaver@aklaver.com

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: select count(*);
Next
From: Geoff Winkless
Date:
Subject: Re: select count(*);