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