| 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: | Whole Thread | Raw Message | 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 |
| 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 |