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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-sql by date

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