Postgres Pro
Downloads
Home   >   mailing lists

Re: count(*) - Mailing list pgsql-sql

From Tom Lane
Subject Re: count(*)
Date
Msg-id 26536.994203684@sss.pgh.pa.us
Whole thread Raw
In response to Re: count(*)  (Martín Marqués <martin@bugs.unl.edu.ar>)
Responses Re: count(*)  (Martín Marqués <martin@bugs.unl.edu.ar>)
List pgsql-sql
Tree view 
>> You probably mean:
>> select car, tit, (select count(*) from auto) from auto

I think he probably wants
select car, tit, count(*) from auto group by car, tit
        regards, tom lane

pgsql-sql by date:

Previous
From: Alex Pilosov
Date:
Subject: Re: count(*)
Next
From: Bhuvan A
Date:
Subject: Re: problem with date/time constants