When using the database toolbox with PostgreSQL, is there a way to make use of the INSERT ... RETURNING syntax (e.g. to insert new rows and return the newly created PKs?

1 次查看（过去 30 天）

Da-Ting Lin 2020-1-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/500761-when-using-the-database-toolbox-with-postgresql-is-there-a-way-to-make-use-of-the-insert-return

评论： Andrew Janke 2020-1-31

As in title:

I am using Matlab 2019b with the database tookbox. I want to execute a statement that will insert multiple new rows into a table, and return the PKs of the newly inserted rows (for a table that uses a serial PK as the default PK value). I have tried using the DB toolbox functions select, execute, and exec with no luck.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Andrew Janke 2020-1-31

I believe that INSERT .. RETURNING is not supported by the Matlab Database Toolbox.

You can come try my "MDBC" Database Toolbox extension, which supports arbitrary result returns from arbitrary SQL statements, and works with INSERT ... RETURNING. https://github.com/apjanke/janklab/blob/c4f108a21856528a801b350e35f33bd78fb2acb9/doc/UserGuide-MDBC.md

请先登录，再进行评论。

请先登录，再回答此问题。