So I’m writing this call log analyzer for the department – something to look at the raw logs output by the phone system, then calculate how many calls are in, out, and total from each person on the team. Based on the Data, I should be able to do things like determine avg. time/call and eventually by the hour call volume stats.
And I’ve got the basic queries worked out to get the per station and per team numbers together.
So all I need to do now is write a function to take care of it. And the docs on my laptop give me the clue that pl/pgsql is the way to go.
…my laptop has the docs for a newer version of postgres, and the version on my server (RHEL3) uses an older version of postgres.
I wonder how much trouble I get in for using the RHEL 4 beta on that box…