Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: IN clause
- From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
- To: Jim Nasby <decibel(at)decibel(dot)org>
- Cc: Marcus Engene <mengpg(at)engene(dot)se>, pgsql-general(at)postgresql(dot)org
- Subject: Re: IN clause
- Date: Tue, 28 Nov 2006 15:01:55 +0100
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(at)svana(dot)org> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate.
Attachment:
signature.asc
Description: Digital signature
- References:
- Re: IN clause
- From: Brandon Aiken
- Re: IN clause
- From: Marcus Engene
- Re: IN clause
- From: Jim Nasby
- Re: IN clause
- Prev by Date: Re: How to increace nightly backup speed
- Next by Date: Re: NULLs ;-)
- Previous by thread: Re: IN clause
- Next by thread: Re: IN clause
- Indexes: