Re: Index on a NULL-value

From: Tobias Brox <tobias(at)nordicbet(dot)com>
To: Bruno Wolff III <bruno(at)wolff(dot)to>, Tobias Brox <tobias(at)nordicbet(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Index on a NULL-value
Date: 2005-05-31 03:45:29
Message-ID: 20050531034529.GJ26100@tobias.exoweb.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

[Bruno Wolff III - Mon at 10:36:33PM -0500]
> You want something like this:
> CREATE INDEX b_is_null ON mock(b) WHERE b IS NULL;

Oh, cool. I wasn't aware that this is possible. This would probably help
us a lot of places. :-)

--
Tobias Brox, Beijing

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Bruno Wolff III 2005-05-31 04:08:01 Re: Index on a NULL-value
Previous Message Bruno Wolff III 2005-05-31 03:36:33 Re: Index on a NULL-value