Thank you, Tom for you answer 2011.03.14 19:17, Tom Lane raÅÄ: Thank you for clearing that for me. I think these 2 sentences in documentation (http://www.postgresql.org/docs/current/interactive/xfunc-volatility.html) would prevent misunderstandings in the future.That function property *allows* the optimizer to invoke the function fewer times than would happen in an un-optimized query. It does not *require* it to do so. -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050 |