Postgres Pro
Downloads
Home   >   mailing lists

Re: SQL -select count- - Mailing list pgsql-sql

From Richard Huxton
Subject Re: SQL -select count-
Date
Msg-id 200211261536.58303.dev@archonet.com
Whole thread Raw
In response to SQL -select count-  ("Giannis" <ogiannhs@yahoo.gr>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Two TIMESTAMPs in one pl/sql function
Next
From: Richard Huxton
Date:
Subject: Re: How does postgres handle non literal string values