[PATCH] inet << indexability

From: Alex Pilosov <alex(at)pilosoft(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: [PATCH] inet << indexability
Date: 2001-06-16 03:13:07
Message-ID: Pine.BSO.4.10.10106152308130.17529-200000@spider.pilosoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

This is second take at indexability of << operator for inet types.

Please take a look at it.

Also, I have a question: I put in a regression test to check that the type
can be indexed, by doing 'explain select ...'. However, the expected
result may vary when the optimizer is tweaked.

I am not sure if its a good idea to check for that, so feel free to not
commit the regression test part of this patch...If there's a better way to
check that the query will use the index in regression test, I'd like to
know too.

-alex

Attachment Content-Type Size
inet-idx.diff text/plain 11.2 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Lincoln Yeoh 2001-06-16 03:20:30 Re: Encrypting pg_shadow passwords
Previous Message Alex Pilosov 2001-06-16 02:13:51 Re: [current] readline breakage