maria-discuss team mailing list archive

[Justin Swanhart <greenlion@xxxxxxxxx>]

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@xxxxxxxxxxxxx>
wrote:

> +1, good idea, today i execute an insert, and a delete
>
> 2015-06-11 16:07 GMT-03:00 Geoff Montee <geoff.montee@xxxxxxxxx>:
>
>> Hi Rhys,
>>
>> On Wed, Jun 10, 2015 at 1:23 AM, Rhys Campbell
>> <Rhys.Campbell@xxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
>> 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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>
>