Transactions and timestamps - Mailing list pgsql-general

From Daniel Åkerud
Subject Transactions and timestamps
Date
Msg-id 002101c11f4e$cbd81250$9b6db5d4@automatic100
Whole thread Raw
Responses Re: Transactions and timestamps
List 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 by date:

Previous
From: "Andrea Aime"
Date:
Subject: How can I know the disk space used by a table?
Next
From: Tom Lane
Date:
Subject: Re: How can I know the disk space used by a table?