> On Apr 22, 2015, at 1:59 PM, Andomar <ando...@aule.net> wrote: > > Is there a way to tell postgres that a function will always return the same > result for the same parameter, within the same transaction?
Yup… read over the Function Volatility Categories <http://www.postgresql.org/docs/9.4/static/xfunc-volatility.html> page and decide which you need. What you’re describing is STABLE (or slightly stricter than STABLE, since STABLE makes that guarantee only for a single statement within a transaction). -- Jason Petersen Software Engineer | Citus Data 303.736.9255 ja...@citusdata.com
signature.asc
Description: Message signed with OpenPGP using GPGMail
