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/ ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
