Mark Rotteveel
unread,May 7, 2023, 9:43:55 AM5/7/23Sign in to reply to author
Sign in to forward
You do not have permission to delete messages in this group
Sign in to report message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to firebir...@googlegroups.com
Looking through the docs folder, I noticed that the PLAN, ORDER BY and
ROWS clauses were added to UPDATE OR INSERT, and the PLAN and ORDER BY
clauses to MERGE as part of the addition of multi-row RETURNING.
The PLAN I can understand, and I can guess at the usefulness of having
an ORDER BY and ROWS with UPDATE OR INSERT if there are multiple
matching records, but I'm not sure of the point of ORDER BY on MERGE.
When would it be useful to have an ORDER BY on MERGE? I'm primarily
looking at it from the perspective of what I can put in the language
reference to say why you'd use it in a MERGE. Is it just to influence
the order of rows returned by RETURNING, or could there be some
additional benefit from ordering?
Mark
--
Mark Rotteveel