select version();
version
--------------------------------------------------------------------------------------------
PostgreSQL 11devel on x86_64-pc-linux-gnu, compiled by gcc (Debian 7.2.0-16) 7.2.0, 64-bit
(1 ligne)
start transaction;
START TRANSACTION
create table all_times(cu timestamp, st timestamp, cl timestamp);
CREATE TABLE
CREATE PROCEDURE pg_temp.insert_times()
LANGUAGE SQL
AS $$
INSERT INTO all_times(cu, st, cl) VALUES (current_timestamp, statement_timestamp(), clock_timestamp());
$$;
CREATE PROCEDURE
CREATE PROCEDURE pg_temp.pl_insert_times()
AS $$
BEGIN
EXECUTE 'INSERT INTO all_times(cu, st, cl) VALUES (current_timestamp, statement_timestamp(), clock_timestamp());';
END;
$$
LANGUAGE plpgsql;
CREATE PROCEDURE
CALL pg_temp.insert_times();
CALL
CALL pg_temp.pl_insert_times();
CALL
select * from all_times;
cu | st | cl
---------------------------+----------------------------+----------------------------
2017-12-04 14:04:50.56782 | 2017-12-04 14:05:26.58376 | 2017-12-04 14:05:26.58455
2017-12-04 14:04:50.56782 | 2017-12-04 14:05:33.441893 | 2017-12-04 14:05:33.442741
(2 lignes)
rollback;
ROLLBACK