From: | arno <arno(at)renevier(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: index scan and functions |
Date: | 2010-07-19 16:25:47 |
Message-ID: | 20100719162547.GA17618@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Le lundi 19 juillet 2010, à 17:09:02 +0100, Sam a écrit :
> On Mon, Jul 19, 2010 at 05:55:48PM +0200, arno wrote:
> > But when using a custom function to compute my where parameter
>
> > inet_to_bigint is a function that transform an inet address its integer representation.
>
> > Is there a way, either to put function return value in a variable, or to tell
> > postgres to still use a sequential scan ?
>
> I'd guess your function is labeled as "VOLATILE". This is saying that
> the function has "side effects", but from the function's name I'd guess
> that it doesn't and the only purpose of calling the function is to get
> its return value. I'd expect that labeling it as STABLE would cause PG
> to do what you're expecting. More details here:
>
> http://www.postgresql.org/docs/current/static/xfunc-volatility.html
Thanks, that's exactly what I was looking for.
From | Date | Subject | |
---|---|---|---|
Next Message | Jennifer Trey | 2010-07-19 16:33:39 | Create table if not exists ... how ?? |
Previous Message | Sam Mason | 2010-07-19 16:09:02 | Re: index scan and functions |