Re: count(*)

From: Alex Pilosov <alex(at)pilosoft(dot)com>
To: Martín Marqués <martin(at)bugs(dot)unl(dot)edu(dot)ar>
Cc: pgsql sql Mailing List <pgsql-sql(at)postgresql(dot)org>
Subject: Re: count(*)
Date: 2001-07-03 22:31:51
Message-ID: Pine.BSO.4.10.10107031830520.18587-100000@spider.pilosoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Tue, 3 Jul 2001, [iso-8859-1] Martn Marqus wrote:

> On Mi 04 Jul 2001 01:18, Alex Pilosov wrote:
> > On Tue, 3 Jul 2001, [iso-8859-1] Martn Marqus 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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Philip Hallstrom 2001-07-03 22:38:54 Re: drop table if exists
Previous Message Alex Pilosov 2001-07-03 22:18:00 Re: count(*)