Re: Guidance on INSERT RETURNING order

On 4/11/23 12:47, Federico wrote:
> Hello list,
> 
https://www.sqlite.org/lang_returning.html#limitations_and_caveats
> 
> Searching the archive seems that a using the INSERT SELECT ORDER BY
> form should be a better solution,
> so the above insert should be rewritten as
> 
>      INSERT INTO t(data)
>      SELECT data FROM (VALUES ('a', 1), ('b', 2), ('c', 3)) as vv(data,
> num) ORDER BY num
>      RETURNING id

Or

with i as (INSERT INTO t(data) VALUES ('a', 1), ('b', 2), ('c', 3) 
returning id)
select i.id from i order by id;

> Sorry for the long email,
> Thanks
> 
>      Federico
> 
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com