Transactions and timestamps

Поиск
Список
Период
Сортировка
От Daniel Åkerud
Тема Transactions and timestamps
Дата
Msg-id 002101c11f4e$cbd81250$9b6db5d4@automatic100
обсуждение исходный текст
Ответы Re: Transactions and timestamps
Список pgsql-general
 
If I do
 
BEGIN
UPDATE some_session set time_stop = CURRENT_TIMESTAMP
UPDATE another_session set time_start = CURRENT_TIMESTAMP
END
 
Is there any chance the current_timestamp will be different?
 
Do I have to first select current_timestamp and then update with a variable? (function?)
 
---
Daniel Åkerud
 
[ Don't underestimate the power of stupid people in large groups]

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