immutable stable volatile

From: <pgsql-general(at)list(dot)coretech(dot)ro>
To: <pgsql-general(at)postgresql(dot)org>
Subject: immutable stable volatile
Date: 2004-12-06 15:29:12
Message-ID: 000001c4dba8$5a43adb0$6600a8c0@razvanr
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

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2004-12-06 15:38:40 Re: Performance tuning on RedHat Enterprise Linux 3
Previous Message Pierre-Frédéric Caillaud 2004-12-06 15:20:02 Re: select single entry and its neighbours using direct-acess to index?