We're sorry but this page doesn't work properly without JavaScript enabled. Please enable it to continue.
Feedback

RETURNING clause ... Have your cake and eat it too!

Formal Metadata

Title
RETURNING clause ... Have your cake and eat it too!
Subtitle
RETURNING result set in DML statements
Title of Series
Number of Parts
637
Author
License
CC Attribution 2.0 Belgium:
You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal purpose as long as the work is attributed to the author in the manner specified by the author or licensor.
Identifiers
Publisher
Release Date2021
LanguageEnglish

Content Metadata

Subject Area
Genre
Abstract
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!