Re: Syntax

[Ron Johnson <ronljohnsonjr@xxxxxxxxx>]

On Thu, Dec 7, 2023 at 3:01 AM arun chirappurath <arunsnmimt@xxxxxxxxx> wrote:

Hi All,

What is the difference or use case for below syntaxes?

do $$ 

declare d int; 

begin 

RAISE INFO 'Script started at %', CURRENT_TIMESTAMP;

update employees set first_name = 'g' where employee_id = 1; get diagnostics d = row_count; raise info 'selected: % rows', d; 

RAISE INFO 'Script finished at %', CURRENT_TIMESTAMP; end;$$;

Or

Just 

Begin;

Update statements 

Commit;

One shows when the statement started, and when you think it ended, while the other doesn't.

https://www.postgresql.org/docs/15/functions-datetime.html#FUNCTIONS-DATETIME-CURRENT

"Since these functions return the start time of the current transaction, their values do not change during the transaction."

What you really want is clock_timestamp().