Re: count(*) - Mailing list pgsql-sql

From Alex Pilosov
Subject Re: count(*)
Date
Msg-id Pine.BSO.4.10.10107031830520.18587-100000@spider.pilosoft.com
Whole thread Raw
In response to Re: count(*)  (Martín Marqués <martin@bugs.unl.edu.ar>)
List pgsql-sql
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.



pgsql-sql by date:

Previous
From: "Jason Watkins"
Date:
Subject: Re: drop table if exists
Next
From: Philip Hallstrom
Date:
Subject: Re: drop table if exists