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: (view raw, whole thread or download thread mbox)
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


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-2017 The PostgreSQL Global Development Group