| From: | Radosław Smogura <rsmogura(at)softperience(dot)eu> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Cc: | pasman pasmański <pasman(dot)p(at)gmail(dot)com> |
| Subject: | Re: New feature: accumulative functions. |
| Date: | 2011-09-25 18:09:05 |
| Message-ID: | 201109252009.05512.rsmogura@softperience.eu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
pasman pasmański <pasman(dot)p(at)gmail(dot)com> Sunday 25 of September 2011 15:19:28
> Hi.
>
> I propose to add "accumulative" flag to a function definition. This
> flag would be set for function f(x) which is accumulative and
> immutable.
>
> This flag allows to use an index on x for clauses containing f(x):
>
> where f(x) = const
I think for this index designe will require that f(x) will be stored,
additional behaviour of fucntion are not required, is quite enaugh that it
will be function.
> where f(x) > const
>
> and so on.
By this assume that "accumulative" function is
(weakly) increasing or decreasing
f such that x < y => f(x) <= f(y)
?
I only may deduce it for idea that search will be faster on index.
Regards,
Radosław Smogura
http://softperience.eu/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | pasman pasmański | 2011-09-25 18:21:00 | Re: New feature: accumulative functions. |
| Previous Message | Tom Lane | 2011-09-25 17:43:28 | Re: pg_dump compress |