Re: which one is faster

From: Marcin Mirosław <marcin(at)mejor(dot)pl>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: which one is faster
Date: 2010-10-26 11:59:03
Message-ID: 4CC6C287.8070803@mejor.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Szymon Guz 2010-10-26 12:05:36 Re: which one is faster
Previous Message Divakar Singh 2010-10-26 11:44:28 Re: Postgres insert performance and storage requirement compared to Oracle