functions with side effect

From: Torsten Förtsch <tfoertsch123(at)gmail(dot)com>
To: PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: functions with side effect
Date: 2018-07-19 14:15:28
Message-ID: CAKkG4_=MTjK6bAJDLM8brKR+U6JggZNhEta6nXgANUyWo8VcDA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

assuming

SELECT nextval('s'), currval('s');

or

SELECT * FROM (VALUES (nextval('s'), currval('s'))) t;

is there any guarantee that the 2 output values are the same?

Thanks,
Torsten

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2018-07-19 14:27:32 Re: functions with side effect
Previous Message Олег Самойлов 2018-07-19 12:06:50 Incorrect description of the WITH CHECK in the row security can lead to the security issue