> select *;
> ----------
> ERROR: SELECT * with no tables specified is not valid
>
> select count(*);
> ----------------
> 1
>
> Is this a must? and why 1?
Hi,
regarding the "why 1" part:
I think that if we accept that
chris=> select 'foo';
?column?
----------
foo
(1 row)
returns 1 row, then naturally
chris=> select count('foo');
count
-------
1
(1 row)
should give a count of 1...
The * might be a bit tricky, though,
since 'select *;' doesn't work.
Bye,
Chris.