[GENERAL] select count(*)

[Rajesh Kumar Mallah]

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.