Re: count(*)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Martín Marqués <martin(at)bugs(dot)unl(dot)edu(dot)ar>
Cc: Alex Pilosov <alex(at)pilosoft(dot)com>, pgsql sql Mailing List <pgsql-sql(at)postgresql(dot)org>
Subject: Re: count(*)
Date: 2001-07-03 23:41:24
Message-ID: 26536.994203684@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

>> 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bhuvan A 2001-07-04 04:45:23 Re: problem with date/time constants
Previous Message Jason Watkins 2001-07-03 23:05:11 Re: drop table if exists