Hai Marc,
MonetDB doesn't support this use case in a single query. It has to be done with a multi-query transaction.
Regards, Jennie
On 21 Apr 2022, at 16:25, Marc Lowenthal marc@scifinsys.com wrote:
Hi all --
Does anyone know if MonetDB has a way of doing "DELETE INTO". The use case is to delete records from a table and save those results into another table with a single query.
Thanks! --- Marc
<image001.png> http://www.scifinsys.com/ Marc Lowenthal Chief Product Officer <image002.png>
marc@scifinsys.com mailto:marc@scifinsys.com <image003.gif> https://www.facebook.com/Scientific-Financial-Systems-105163315113238 <image004.gif> https://www.linkedin.com/company/scientific-financial-systems-inc/ <image005.png> https://scifinsys.com/ SFS is hiring! https://www.linkedin.com/jobs/view/2995084707/?refId=W7U9EW8bJ8ZxuymdxbxPqw%... https://www.linkedin.com/jobs/view/2995084707/?refId=W7U9EW8bJ8ZxuymdxbxPqw%3D%3D
The entire content of this email message is confidential. This also applies to any files attached to it. This email is intended for an individual or entity to whom they are addressed. In case you are not the addressee of this email, and you have received it in error, immediately contact the system manager. The information in this email is very sensitive, and it is intended for the specific addressee. This email should not be disseminated, distributed or copied. If you have received this email and it was not for you, make sure to immediately notify the sender by email and afterwards delete this email from your system. Disclosing, copying, distributing, or taking any action in reliance to the email content is strictly prohibited. Consider yourself notified. _______________________________________________ users-list mailing list -- users-list@monetdb.org mailto:users-list@monetdb.org To unsubscribe send an email to users-list-leave@monetdb.org mailto:users-list-leave@monetdb.org