Received: from bugs.unl.edu.ar (bugs.unl.edu.ar [168.96.132.208]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f64Ii3a15715 for ; Wed, 4 Jul 2001 14:44:06 -0400 (EDT) (envelope-from martin@bugs.unl.edu.ar) Received: by bugs.unl.edu.ar (Postfix, from userid 1004) id 1D4AF2AB3B; Wed, 4 Jul 2001 15:44:07 +0300 (GMT) Content-Type: text/plain; charset="iso-8859-1" From: =?iso-8859-1?q?Mart=EDn=20Marqu=E9s?= To: Tom Lane Subject: Re: count(*) Date: Wed, 4 Jul 2001 15:44:05 +0300 X-Mailer: KMail [version 1.2] Cc: Alex Pilosov , pgsql sql Mailing List References: <0107031917490C.11918@bugs> <26536.994203684@sss.pgh.pa.us> In-Reply-To: <26536.994203684@sss.pgh.pa.us> MIME-Version: 1.0 Message-Id: <01070415440500.16423@bugs> Content-Transfer-Encoding: 8bit X-Archive-Number: 200107/39 X-Sequence-Number: 3820 On Mié 04 Jul 2001 02:41, Tom Lane wrote: > >> 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 Does this mean I would get the same as if I didn't have the count(*), but with the additional count(*) column at the end of each row? Saludos... :-) -- Cualquiera administra un NT. Ese es el problema, que cualquiera administre. ----------------------------------------------------------------- Martin Marques | mmarques@unl.edu.ar Programador, Administrador | Centro de Telematica Universidad Nacional del Litoral -----------------------------------------------------------------