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 f63MR7a15032 for ; Tue, 3 Jul 2001 18:27:08 -0400 (EDT) (envelope-from martin@bugs.unl.edu.ar) Received: by bugs.unl.edu.ar (Postfix, from userid 1004) id A41EC2AB3A; Tue, 3 Jul 2001 19:27:16 +0300 (GMT) Content-Type: text/plain; charset="iso-8859-1" From: =?iso-8859-1?q?Mart=EDn=20Marqu=E9s?= To: Alex Pilosov Subject: Re: count(*) Date: Tue, 3 Jul 2001 19:27:15 +0300 X-Mailer: KMail [version 1.2] Cc: pgsql sql Mailing List References: In-Reply-To: MIME-Version: 1.0 Message-Id: <0107031927150D.11918@bugs> Content-Transfer-Encoding: 8bit X-Archive-Number: 200107/29 X-Sequence-Number: 3810 On Mié 04 Jul 2001 01:31, Alex Pilosov wrote: > On Tue, 3 Jul 2001, [iso-8859-1] Martín Marqués wrote: > > On Mié 04 Jul 2001 01:18, Alex Pilosov wrote: > > > On Tue, 3 Jul 2001, [iso-8859-1] Martín Marqués wrote: > > > > Is it illegal to make a select query with a count(*) in the list of > > > > expressions to select? > > > > > > > > Ex: > > > > > > > > select car,tit,count(*) from auto > > > > > > You probably mean: > > > > Well, not the best example..... > > How about if I have a WHERE clause? I have to add it twice? > > Yes. I was lmost sure I could add the count(*) in the select, but now that I see some old scripts I have, I notic that I was wrong. Shame on me! Thanks! 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 -----------------------------------------------------------------