Re: tid_le comparison for tuple id (ctid) values?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: tid_le comparison for tuple id (ctid) values?
Дата
Msg-id 4271.1132607968@sss.pgh.pa.us
обсуждение исходный текст
Ответ на tid_le comparison for tuple id (ctid) values?  (george young <gry@ll.mit.edu>)
Ответы Re: tid_le comparison for tuple id (ctid) values?  (george young <gry@ll.mit.edu>)
Список pgsql-sql
george young <gry@ll.mit.edu> writes:
>    update steps set x=x||'X' from steps s where steps.key1=s.key1 and steps.key2=s.key2 and step.ctid<s.ctid;

> But this fails because there is no less-than operator (or function) on
> type "tid".

Probably a good thing, too, since if there was it wouldn't have anything
reliable to do with the age of the tuple.
        regards, tom lane


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

Предыдущее
От: george young
Дата:
Сообщение: tid_le comparison for tuple id (ctid) values?
Следующее
От: "Bath, David"
Дата:
Сообщение: Re: idea for a geographically distributed database: how best to implement?