One word in PostgreSQL unlocked a 9x performance improvement

Re:One word in PostgreSQL unlocked a 9x performance improvement by badrequest on Sunday June 14, 2020 @03:28PM (#23520579)

All that is well and good, but RETURNING is a Postgres feature, not part of the SQL standard. I don't think a standard SQL textbook (especially one targeting something like MySQL/Sqlite) would have taught the author about it.

[ Parent | on HN ]

Re:One word in PostgreSQL unlocked a 9x performance improvement by fabian2k on Sunday June 14, 2020 @03:34PM (#23520621)

I was quite surprised when I found out that RETURNING is actually a Postgres feature, and not standard. It just felt like such an obvious and extremely useful thing to have.

[ Parent | on HN ]

Re:One word in PostgreSQL unlocked a 9x performance improvement by AdrianB1 on Sunday June 14, 2020 @04:11PM (#23520900)

RETURNING exists also in Oracle PL/SQL and it is called OUTPUT in T-SQL. It may exist in other SQL variants.

[ Parent | on HN ]