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
