RETURNING clause ... Have your cake and eat it too! : RETURNING result set in DML statements

RETURNING retrieves the modified, inserted or deleted values of columns. Without RETURNING, there would be a need to run an extra SELECT query.So, along with many other benefits like triggering actions in your application based on what really gets modified, it helps to avoid a round trip and still g...

Full description

Bibliographic Details
Main Author: Deodhar, Rucha
Format: Article in Journal/Newspaper
Language:English
Published: FOSDEM VZW 2021
Subjects:
Information Technology
DML
Online Access:https://dx.doi.org/10.5446/52854
https://av.tib.eu/media/52854
Description
Summary:RETURNING retrieves the modified, inserted or deleted values of columns. Without RETURNING, there would be a need to run an extra SELECT query.So, along with many other benefits like triggering actions in your application based on what really gets modified, it helps to avoid a round trip and still gets the same job done! Number of queries running can be important for performance of your application as well. So you can have your cake and eat it too!

Similar Items