Re: New feature: accumulative functions.

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/

In response to

Browse pgsql-general by date

  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