Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f63Nfka43512 for ; Tue, 3 Jul 2001 19:41:46 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id f63NfOJ26539; Tue, 3 Jul 2001 19:41:25 -0400 (EDT) To: =?iso-8859-1?q?Mart=EDn=20Marqu=E9s?= cc: Alex Pilosov , pgsql sql Mailing List Subject: Re: count(*) In-reply-to: <0107031917490C.11918@bugs> References: <0107031917490C.11918@bugs> Comments: In-reply-to =?iso-8859-1?q?Mart=EDn=20Marqu=E9s?= message dated "Tue, 03 Jul 2001 19:17:49 +0300" Date: Tue, 03 Jul 2001 19:41:24 -0400 Message-ID: <26536.994203684@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200107/35 X-Sequence-Number: 3816 >> 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