| From: | Michael Glaesemann <grzm(at)myrealbox(dot)com> |
|---|---|
| To: | "FERREIRA William (COFRAMI)" <william(dot)ferreira(at)airbus(dot)com> |
| Cc: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: CURRENT_TIME |
| Date: | 2005-03-15 14:41:40 |
| Message-ID: | a87cd9e68060486a144ac2b8dba0d26d@myrealbox.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mar 15, 2005, at 23:21, FERREIRA William (COFRAMI) wrote:
> i need to know the execution time of a part of my pl/pgsql code
>
> so, i tried to use CURRENT_TIME :
<snip />
> 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
You're probably looking for timeofday(). See the docs at
http://www.postgresql.org/docs/8.0/interactive/functions-
datetime.html#FUNCTIONS-DATETIME-CURRENT
Hope this helps.
Michael Glaesemann
grzm myrealbox com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-03-15 14:46:54 | Re: plpython function problem workaround |
| Previous Message | Fred Blaise | 2005-03-15 14:35:31 | pg/plsql question |