Fighting with PostgreSQL *geek*

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…

About Kevin Sonney

Kevin Sonney - who, contrary to popular opinion was NOT raised by wolves - grew up in central North Carolina. He fell into the technology field by accident in 1991, when he gave up the wild and crazy lifestyle of an on-air AM radio DJ to become a mundane technical support monkey. The technology industry has never really recovered from this. Kevin has worked for such names as IBM, Red Hat, webslingerZ, and Lulu Technologies (we won't mention the ones that didn't survive the experience). He currently works as a Linux Administrator for Apptio. In his spare time he rescues stray animals and plays video games with his two sons. His wife, we're sad to say, helps him get past the really hard bits. Kevin is still not very mundane, he just got better at hiding it.
This entry was posted in Uncategorized. Bookmark the permalink.

1 Response to Fighting with PostgreSQL *geek*

  1. detritus says:

    “I wonder how much trouble I get in for using the RHEL 4 beta on that box”

    Probably less trouble than you’d get in for using Suse.

Comments are closed.