Thread: Re: [COMMITTERS] pgsql: Add generate_subscripts, a series-generation function which

Tom Lane wrote:
> alvherre@postgresql.org (Alvaro Herrera) writes:
> > Add generate_subscripts, a series-generation function which generates an
> > array's subscripts.
> 
> Why are these marked volatile in pg_proc?  Surely they generate the
> same outputs given the same inputs, and therefore qualify as immutable.

Hmm, true.

I'll change the four generate_series variants too -- they are marked
volatile as well.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

Alvaro Herrera <alvherre@commandprompt.com> writes:
> I'll change the four generate_series variants too -- they are marked
> volatile as well.

I don't think the system actually pays much attention to the volatility
marking of set-returning functions at the moment, so it wouldn't be too
surprising if they were all wrong :-(.  Still, we may as well get the
catalog entries right for possible future use.
        regards, tom lane