← Back to team overview

maria-discuss team mailing list archive

Re: DELETE FROM RETURNING

 

Hi,

Why were you chastised for a feature request?  A FR is just that, a
request.  A FR is not an agreement that a feature will be implemented.

Confused,

--Justin

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! ;-)
>
> -----Original Message-----
> From: Geoff Montee [mailto:geoff.montee@xxxxxxxxx]
> Sent: 09 June 2015 20:16
> To: Rhys Campbell; MariaDB discuss
> Subject: Re: [Maria-discuss] DELETE FROM RETURNING
>
> Hi Rhys,
>
> On Tue, Jun 9, 2015 at 8:29 AM, Rhys Campbell <
> Rhys.Campbell@xxxxxxxxxxxxxxxxx> wrote:
> >
> > Just regarding the RETURNING feature introduced into MariaDB 10.0.5
> > https://mariadb.com/kb/en/mariadb/delete/
> >
> > It would be useful, similar to the OUTPUT clause in MSSQL, if we could
> > INSERT the data sent back from a returning clause in a single statement.
> > Something like…
> >
> > CREATE TABEL deleted_ids
> >
> > (
> >
> >                 Id INT NOT NULL PRIMARY KEY
> >
> > );
> >
> > INSERT INTO deleted_ids
> >
> > DELETE FROM t1
> >
> > WHERE id < 999
> >
> > RETURNING id;
> >
>
> This might be better suited as a feature request on the MariaDB JIRA.
> If you create an account, you should be able to submit it here:
>
> https://mariadb.atlassian.net
>
> Thanks,
>
> 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
>

References