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:18:00
Message-ID: Pine.BSO.4.10.10107031817120.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:

> 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

In response to

  • count(*) at 2001-07-03 14:54:46 from Martín Marqués

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Alex Pilosov 2001-07-03 22:31:51 Re: count(*)
Previous Message Jason Watkins 2001-07-03 21:24:29 drop table if exists