Re: Index optimization ? - Mailing list pgsql-general

From Bo Lorentsen
Subject Re: Index optimization ?
Date
Msg-id 41EA876A.3080400@netgroup.dk
Whole thread Raw
In response to Re: Index optimization ?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Index optimization ?  (Michael Glaesemann <grzm@myrealbox.com>)
Re: Index optimization ?  (Ragnar Hafstað <gnari@simnet.is>)
List pgsql-general
Tom Lane wrote:

>http://developer.postgresql.org/docs/postgres/xfunc-volatility.html
>
>
Ok, thanks I see why there is these three differant function types, but
I don't quite understand why the value from a volatile function, can't
be used as a index key. Is this because there is no return type garanti,
for the voilatile function too ?

Will the only possible way to fix this be to make a volatile function
with a return type (I know this is not possible now, but in theory) ?

/BL

pgsql-general by date:

Previous
From: "Raymond O'Donnell"
Date:
Subject: Re: PostgreSQL 8 on windows very slow
Next
From: Michael Glaesemann
Date:
Subject: Re: Index optimization ?