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 f63MHZa10583 for ; Tue, 3 Jul 2001 18:17:36 -0400 (EDT) (envelope-from martin@bugs.unl.edu.ar) Received: by bugs.unl.edu.ar (Postfix, from userid 1004) id B09D82AB3A; Tue, 3 Jul 2001 19:17:50 +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:17:49 +0300 X-Mailer: KMail [version 1.2] Cc: pgsql sql Mailing List References: In-Reply-To: MIME-Version: 1.0 Message-Id: <0107031917490C.11918@bugs> Content-Transfer-Encoding: 8bit X-Archive-Number: 200107/28 X-Sequence-Number: 3809 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: > select car, tit, (select count(*) from auto) from auto Well, not the best example..... How about if I have a WHERE clause? I have to add it twice? 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 -----------------------------------------------------------------