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.