Re: Review: B-Tree emulation for GIN - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: Review: B-Tree emulation for GIN
Date
Msg-id 1232388160.7281.129.camel@jdavis
Whole thread Raw
In response to Re: Review: B-Tree emulation for GIN  (Teodor Sigaev <teodor@sigaev.ru>)
Responses Re: Review: B-Tree emulation for GIN
List pgsql-hackers
On Mon, 2009-01-19 at 20:15 +0300, Teodor Sigaev wrote:
> Changes:
> - use NULL as left-most value. It's safe because NULL numeric value
>    cannot be an argument for any function except gin_numeric_cmp and it
>    cannot be returned in regular SQL query.

gin_numeric_cmp() can be called from regular SQL. I missed this before,
but that function will segfault if you call gin_numeric_cmp(NULL, 1) (in
v0.7 at least).

I know you mean a C NULL, not a SQL NULL, but it reminded me to test SQL
NULL.

And how does GIN handle SQL NULL values in the column? Does it index
them at all, or just ignore them?

Regards,Jeff Davis



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PATCHES] GIN improvements
Next
From: Teodor Sigaev
Date:
Subject: Re: [PATCHES] GIN improvements