Re: which one is faster

Поиск
Список
Период
Сортировка
От Szymon Guz
Тема Re: which one is faster
Дата
Msg-id AANLkTi=sOW-X+DcZPaBk1S_sHzJV97XrSOHmsSXsYpeo@mail.gmail.com
обсуждение исходный текст
Ответ на Re: which one is faster  (Marcin Mirosław <marcin@mejor.pl>)
Ответы Re: which one is faster  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
Список pgsql-performance


2010/10/26 Marcin Mirosław <marcin@mejor.pl>
W dniu 26.10.2010 12:59, Szymon Guz pisze:
> both queries are the same.

IMHO they aren't the same, but they returns the same value in this case.
I mean count(field) doesn't count NULL values, count(*) does it.
I'm writing this only for note:)
Regards


Yup, indeed. I omitted that note, as it was written that the field is primary key :).

regards
Szymon 

В списке pgsql-performance по дате отправления:

Предыдущее
От: Marcin Mirosław
Дата:
Сообщение: Re: which one is faster
Следующее
От: Grzegorz Jaśkiewicz
Дата:
Сообщение: Re: which one is faster