Christopher Kings-Lynne kirjutas R, 07.03.2003 kell 07:28:
> Yeah, it's not really a problem for me, I just put the extra clause in.
> 
> Is indexing excluding NULLs a common application of partial indexes? 

For me it is ;)

> It's
> basically all I use it for, when a column has like 90-95% NULLS and I want
> to exclude them from the index.  

> Is it worth hard-coding in the IS NOT NULL case?

I'd vote for it.

------------
Hannu

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Reply via email to