[GENERAL] CURRENT_TIME

[FERREIRA William (COFRAMI)]

Title: RE: [GENERAL] Convert Cursor to array

hi

 

i need to know the execution time of a part of my pl/pgsql code

 

so, i tried to use CURRENT_TIME :

 

t_time_d TIME;
t_time_f TIME;
t_diff TIME;

 

select CURRENT_TIME into t_time_d;

 

    //the traitment

 

 

select CURRENT_TIME into t_time_f;
t_diff=t_time_f-t_time_d;
raise notice 'DEBUT : % | FIN : % | DIFF : % | POUR : %',t_time_d,t_time_f,t_diff;

 

my function is recursive and the problem is that i always get the same result for each iteration

t_time_d is set at the first iteration and doesn't change

 

thanks