Hi,

Really, the SQL-2003 standard syntax would be nice (implementing non-recursive CTE is mostly trivial, btw):

WITH moved_rows AS (
    DELETE FROM products
    WHERE
        "date" >= '2010-10-01' AND
        "date" < '2010-11-01'
    RETURNING *
)
INSERT INTO products_log
SELECT * FROM moved_rows;

On Thu, Jun 11, 2015 at 12:09 PM, Roberto Spadim <roberto@spadim.com.br> wrote:

+1, good idea, today i execute an insert, and a delete

2015-06-11 16:07 GMT-03:00 Geoff Montee <geoff.montee@gmail.com>:
Hi Rhys,

On Wed, Jun 10, 2015 at 1:23 AM, Rhys Campbell
<Rhys.Campbell@tradingscreen.com> wrote:
> " This might be better suited as a feature request on the MariaDB JIRA."
>
> I got chastised for doing that before so I'm trying to play nice! ;-)
>

I don't know why you were chastised in the past, but I've added this
to the JIRA:

https://mariadb.atlassian.net/browse/MDEV-8307

It sure sounds like a useful feature to me. Thanks for the suggestion!

Geoff

_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp

--
Roberto Spadim
SPAEmpresarial - Software ERP
Eng. Automação e Controle

_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp