> It always crashes on this query:
> 
> DELETE
>     FROM progress
>     WHERE EXISTS (
>         SELECT true
>             FROM finalization
>             WHERE finalization.id=progress.id
>             AND finalization.category=active
>     );
> 

My bad, this should read:

DELETE
    FROM progress
    WHERE EXISTS (
        SELECT true
            FROM finalization
            WHERE finalization.id=progress.id
            AND finalization.category='active'
    );

Best regards,

Isidor

------------------------------------------------------------------------------
_______________________________________________
Monetdb-developers mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-developers

Reply via email to