ainpoissee wrote:

>
> BTW why is COUNT(1) not legal? I thought thats the most efficient way
> to get count as there is no need to look up specific field(s), just
> number of matching rows...

COUNT(*) is just a special form of the function. It operates at the row
level and it doesn't look up fields at all.


Dmitry