| From: | Christoph Berg <myon(at)debian(dot)org> |
|---|---|
| To: | Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru> |
| Cc: | Simon Riggs <simon(at)2ndquadrant(dot)com>, Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Surjective functional indexes |
| Date: | 2017-09-13 07:51:44 |
| Message-ID: | 20170913075144.auntuti3usqp2jl5@msg.df7cb.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Re: Konstantin Knizhnik 2017-09-01 <f530ede0-1bf6-879c-c362-34325514f692(at)postgrespro(dot)ru>
> + Functional index is based on on projection function: function which extract subset of its argument.
> + In mathematic such functions are called non-injective. For injective function if any attribute used in the indexed
> + expression is changed, then value of index expression is also changed.
This is Just Wrong. I still think what you are doing here doesn't have
anything to do with the function being injective or not.
Christoph
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ashutosh Sharma | 2017-09-13 07:57:23 | Re: [PATCH] Pageinspect - add functions on GIN and GiST indexes from gevel |
| Previous Message | Alexey Chernyshov | 2017-09-13 07:45:41 | Re: [PATCH] Pageinspect - add functions on GIN and GiST indexes from gevel |