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...
Main Author: | |
---|---|
Format: | Article in Journal/Newspaper |
Language: | English |
Published: |
FOSDEM VZW
2021
|
Subjects: | |
Online Access: | https://dx.doi.org/10.5446/52854 https://av.tib.eu/media/52854 |
id |
ftdatacite:10.5446/52854 |
---|---|
record_format |
openpolar |
spelling |
ftdatacite:10.5446/52854 2023-05-15T16:01:40+02:00 RETURNING clause ... Have your cake and eat it too! : RETURNING result set in DML statements Deodhar, Rucha 2021 https://dx.doi.org/10.5446/52854 https://av.tib.eu/media/52854 en eng FOSDEM VZW Information Technology Conference/Talk MediaObject article Audiovisual 2021 ftdatacite https://doi.org/10.5446/52854 2021-11-05T12:55:41Z 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! Article in Journal/Newspaper DML DataCite Metadata Store (German National Library of Science and Technology) |
institution |
Open Polar |
collection |
DataCite Metadata Store (German National Library of Science and Technology) |
op_collection_id |
ftdatacite |
language |
English |
topic |
Information Technology |
spellingShingle |
Information Technology Deodhar, Rucha RETURNING clause ... Have your cake and eat it too! : RETURNING result set in DML statements |
topic_facet |
Information Technology |
description |
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! |
format |
Article in Journal/Newspaper |
author |
Deodhar, Rucha |
author_facet |
Deodhar, Rucha |
author_sort |
Deodhar, Rucha |
title |
RETURNING clause ... Have your cake and eat it too! : RETURNING result set in DML statements |
title_short |
RETURNING clause ... Have your cake and eat it too! : RETURNING result set in DML statements |
title_full |
RETURNING clause ... Have your cake and eat it too! : RETURNING result set in DML statements |
title_fullStr |
RETURNING clause ... Have your cake and eat it too! : RETURNING result set in DML statements |
title_full_unstemmed |
RETURNING clause ... Have your cake and eat it too! : RETURNING result set in DML statements |
title_sort |
returning clause ... have your cake and eat it too! : returning result set in dml statements |
publisher |
FOSDEM VZW |
publishDate |
2021 |
url |
https://dx.doi.org/10.5446/52854 https://av.tib.eu/media/52854 |
genre |
DML |
genre_facet |
DML |
op_doi |
https://doi.org/10.5446/52854 |
_version_ |
1766397430220193792 |