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 
 
 
Marc Lowenthal
Chief Product Officer 
<image002.png>
 
 
 
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
To unsubscribe send an email to users-list-leave@monetdb.org