Skip site navigation (1) Skip section navigation (2)

Re: SQL -select count-

From: Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
To: Giannis <ogiannhs(at)yahoo(dot)gr>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: SQL -select count-
Date: 2002-11-27 08:00:37
Message-ID: (view raw or whole thread)
Lists: pgsql-sql
On Tue, 19 Nov 2002, 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?

θα πάρεις το πλήθος των κολόνων !! που δεν είναι null.

Γιατι δεν κάνεις ένα τέστ μόνος?

> __________________________________________________
> Do you Yahoo!?
> Yahoo! Web Hosting - Let the expert host your site
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
tel:    +30-10-8981112
fax:    +30-10-8981877
email:  achill(at)matrix(dot)gatewaynet(dot)com

In response to

pgsql-sql by date

Next:From: Luis SousaDate: 2002-11-27 10:05:24
Subject: Re: SQL query help!
Previous:From: Tom LaneDate: 2002-11-27 02:14:54
Subject: Re: [SQL] [SQL/BUGS] (possible) inconsistent behaviour of timestamp?

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group