Re: [SQL] Two TIMESTAMPs in one pl/sql function

On Tuesday 26 Nov 2002 1:54 pm, Rison, Stuart wrote: > Hi, > > I'm trying to time a pl/sql function using a rougn and ready method, > basically: print a TIMESTAMP at the begining of the function, print a > TIMESTAMP at the end of the function. [snip] > Gives me: > > testdb2=# select timer(); > NOTI

[SQL] Two TIMESTAMPs in one pl/sql function

Hi, I'm trying to time a pl/sql function using a rougn and ready method, basically: print a TIMESTAMP at the begining of the function, print a TIMESTAMP at the end of the function. So...: CREATE OR REPLACE FUNCTION timer() RETURNS INTEGER AS ' DECLARE timer1 TIMESTAMP; timer2 T