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 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

http://www.scifinsys.com/ Marc Lowenthal Chief Product Officer

marc@scifinsys.com mailto:marc@scifinsys.com https://www.facebook.com/Scientific-Financial-Systems-105163315113238 https://www.linkedin.com/company/scientific-financial-systems-inc/ https://scifinsys.com/ SFS is hiring! https://www.linkedin.com/jobs/view/2995084707/?refId=W7U9EW8bJ8ZxuymdxbxPqw%... https://www.linkedin.com/jobs/view/2995084707/?refId=W7U9EW8bJ8ZxuymdxbxPqw%...

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