immutable stable volatile

From: "PostgreSQL general mail list" <pgsql-general(at)list(dot)coretech(dot)ro>
To: pgsql-general(at)postgresql(dot)org
Subject: immutable stable volatile
Date: 2004-12-06 18:40:11
Message-ID: 20041206184011.8562035E0F@mail01.chs.coretech.ro
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


hello,

I have read the documentation couple of times and I still can not figure out
the following aspects.

if a function does insert/update/delete it needs to be stable or volatile ?
if a immutable function executes 'nextval' should itself be also volatile ?

thanks,
Razvan Radu

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-12-06 18:41:08 Re: immutable stable volatile
Previous Message Jan Wieck 2004-12-06 18:19:19 Re: When to encrypt