Subject Re: [firebird-support] Re: Trouble with BETWEEN operator
Author Dmitry Yemanov
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.