Hi, Andy.
I assume you are doing this in a loop? Many Many Many times? cuz:
Yes. Here are the variations I have benchmarked (times are best of three):
Variation #0
Variation #1
Variation #2
Variation #3
Variation #4
What I would like is along Variation #5:
PGTYPESdate_mdyjul(taken_year, p_month1, p_day1)
Time: 2.3s
I find it interesting that variation #2 is half a second slower than variation #1.
The other question I have is: why does PG seem to discard the results? In pgAdmin3, I can keep pressing F5 and (before 8.4.4?) the results came back in 4s for the first response then 1s in subsequent responses.
Dave