Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group