Postgres Pro
Downloads
Home   >   mailing lists

functions with side effect - Mailing list pgsql-general

From Torsten Förtsch
Subject functions with side effect
Date
Msg-id CAKkG4_=MTjK6bAJDLM8brKR+U6JggZNhEta6nXgANUyWo8VcDA@mail.gmail.com
Whole thread Raw
Responses Re: functions with side effect  (Laurenz Albe <laurenz.albe@cybertec.at>)
Re: functions with side effect  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Олег Самойлов
Date:
Subject: Incorrect description of the WITH CHECK in the row security can lead to the security issue
Next
From: Laurenz Albe
Date:
Subject: Re: functions with side effect