On Mon, Nov 27, 2006 at 05:24:31PM -0600, Jim Nasby wrote: > In any case, like Oracle, PostgreSQL does not index NULL values (at > least not in btree). Actually, PostgreSQL does store NULL values in an index, otherwise you could never use them for full index scans (think multicolumn indexes). You can't use the index for IS NULL tests, although patches exist for that. Have a nice day, -- Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate.
Attachment:
signature.asc
Description: Digital signature
