Re: Index optimization ?

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Bo Lorentsen <bl(at)netgroup(dot)dk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Index optimization ?
Date: 2005-01-15 23:20:05
Message-ID: 20050115232005.GA10957@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, Jan 15, 2005 at 11:28:08PM +0100, Bo Lorentsen wrote:
> Michael Fuhr wrote:
>
> >currval() is volatile. See "Function Volatility Categories" in the
> >"Extending SQL" chapter of the documentation and search the list
> >archives for past discussion of currval()'s volatility.
> >
> Hmm, I can't find that chapter in the 7.4 manual, or am I looking the
> wrong place ? I really like to understand this !

Sorry...apparently that section is in the development documentation
but not in the 7.x doc. Tom Lane posted the link but here it is
again:

http://developer.postgresql.org/docs/postgres/xfunc-volatility.html

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Edmund Dengler 2005-01-16 00:00:53 Re: Multi-column indexes
Previous Message Tom Lane 2005-01-15 23:03:30 Re: Index optimization ?