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: Pine.LNX.4.44.0211270958200.24730-100000@matrix.gatewaynet.com (view raw or flat)
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
> http://webhosting.yahoo.com
>
> ---------------------------(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
Greece
tel:    +30-10-8981112
fax:    +30-10-8981877
email:  achill(at)matrix(dot)gatewaynet(dot)com
        mantzios(at)softlab(dot)ece(dot)ntua(dot)gr


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-2014 The PostgreSQL Global Development Group