Re: [PERFORM] Analysis Function

[David Jarvis]

Hi,

I added an explicit cast in the SQL:

        dateserial(extract(YEAR FROM
m.taken)::int,'||p_month1||','||p_day1||') d1,
        dateserial(extract(YEAR FROM
m.taken)::int,'||p_month2||','||p_day2||') d2

The function now takes three integer parameters; there was no performance
loss.

Thank you.

Dave