Обсуждение: Result order of Insert ... returning

Поиск
Список
Период
Сортировка

Result order of Insert ... returning

От
fsfeel
Дата:
Hello!
I'm using INSERT ... RETURNING with multiply values, for example
INSERT INTO links.tags (name) VALUES ('tag x'), ('tag y') RETURNING
id, name
and fetch result. Is it guaranteed that order of returned rows will
always match order of values (that is, first returned row will be with
name='tag x' and second with 'tag y') or not? If not, is there any
nice method to order the result accordingly or i have to do it in
application (e.g. comparing "name"s)?
Thanks.