Re: SQL -select count-

From: Richard Huxton <dev(at)archonet(dot)com>
To: "Giannis" <ogiannhs(at)yahoo(dot)gr>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: SQL -select count-
Date: 2002-11-26 15:36:58
Message-ID: 200211261536.58303.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Tuesday 19 Nov 2002 5:06 pm, Giannis wrote:
> when I do :
>
> select count(column_name) from table_name
>
> should I get the count for all columns or just those which are not null?

Just "not null" - use count(*) or count(0) for a count of rows.

--
Richard Huxton

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2002-11-26 15:52:20 Re: Are sub-select error suppressed?
Previous Message Richard Huxton 2002-11-26 15:35:02 Re: How does postgres handle non literal string values