Re: Syntax - Mailing list pgsql-general

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;