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

From Alex Pilosov
Subject Re: count(*)
Date
Msg-id Pine.BSO.4.10.10107031817120.18587-100000@spider.pilosoft.com
Whole thread Raw
In response to 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:

> 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





pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: simple function crashes my postmaster
Next
From: Tom Lane
Date:
Subject: Re: count(*)