Subject Re: [firebird-support] * vs fieldname
Author Nick Upson
agreed, that's part of the discussion I expect to have today with the
author of the code in question

On 14/09/2007, Kjell Rilbe <kjell@...> wrote:
> Yes, but you should probably use count(*) because that's what you mean.
> Using count(<fieldname>) requires you (someone else reading your code)
> to examine the nullability of <fieldname> to be able to determine if it
> will result in the same thing as count(*) or not.
>
> This is usually more important than you think - readability.
>
> Kjell
>
> Nick Upson wrote:
>
> > Thanks everyone, so if myfieldname is not nullable they will always be
> > equivalent
> --
> --------------------------------------
> Kjell Rilbe
> DataDIA AB
> E-post: kjell@...
> Telefon: 08-761 06 55
> Mobil: 0733-44 24 64
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>