OID order = INSERT order?

Поиск
Список
Период
Сортировка
От Justin Hawkins
Тема OID order = INSERT order?
Дата
Msg-id 87hegubt0a.fsf@weasel.internode.com.au
обсуждение
Ответы Re: OID order = INSERT order?
Re: OID order = INSERT order?
Re: OID order = INSERT order?
Список pgsql-general
Hi folks,

I am converting a legacy (DBM file backend) app to SQL. The current
storage scheme utlizes ordered list values on objects. To emulate this
I'm just doing multiple INSERTs on a table.

I need to make sure they will come back out in the same order, every
time though.

When I fetch values back from the table, if I 'ORDER BY oid', will I
always get them back in the same order I put them in?

This is happening inside a transaction, if it matters.

        - Justin

--
Justin Hawkins
Internode Professional Access


В списке pgsql-general по дате отправления: