Postgres Pro
Downloads
Home   >   mailing lists

select count(*) - Mailing list pgsql-general

From Rajesh Kumar Mallah
Subject select count(*)
Date
Msg-id AANLkTikijnqxh1zLJHQSqh6Ww82Y068PQ0Du9QO2LUmM@mail.gmail.com
Whole thread Raw
Responses Re: select count(*)
List pgsql-general
Tree view
Dear List ,

if we simply do select count(*) and not specify any table then it gives 1 eg:

bric=# SELECT count(*)  from job ;
 count
-------
  2380
(1 row)

bric=# SELECT count(*)  job ;
 job
-----
   1
(1 row)



bric=# SELECT count(*)  ;
 count
-------
     1
(1 row)



bric=# SELECT count(*)  job_non_exist ;
 job_non_exist
---------------
             1
(1 row)

bric=# SELECT count(*)  jo1b ;
 jo1b
------
    1
(1 row)

bric=# SELECT count(*)  none ;
ERROR:  syntax error at or near "none"
LINE 1: SELECT count(*)  none ;


I fail to see any  progression ?


regds
mallah.

pgsql-general by date:

Previous
From: runner
Date:
Subject: Mounting file system for WAL on Solaris 10
Next
From: "Jaiswal Dhaval Sudhirkumar"
Date:
Subject: Re: ER tool that supports domains and custom types?