Re: [GENERAL] Route Miles

2005-09-09 Thread Terry Lee Tucker
ge --- > From: Terry Lee Tucker <[EMAIL PROTECTED]> > To: pgsql-general@postgresql.org > Sent: Fri, 9 Sep 2005 10:49:59 -0400 > Subject: Re: [GENERAL] Route Miles > > > Matt, > > > > This is a logistics package and we move freight for customers for

Re: [GENERAL] Route Miles

2005-09-09 Thread Jim Buttafuoco
--- Original Message --- From: Terry Lee Tucker <[EMAIL PROTECTED]> To: pgsql-general@postgresql.org Sent: Fri, 9 Sep 2005 10:49:59 -0400 Subject: Re: [GENERAL] Route Miles > Matt, > > This is a logistics package and we move freight for customers for a fee. > Quite >

Re: [GENERAL] Route Miles

2005-09-09 Thread Terry Lee Tucker
Matt, This is a logistics package and we move freight for customers for a fee. Quite often that fee is based on the number of miles traveled. The vast majority of our customers demand that we calculate their rate using either PCMiler or Rand McNally. A handful use their own mileage calcuations

Re: [GENERAL] Route Miles

2005-09-09 Thread Matt Miller
On Fri, 2005-09-09 at 10:13 -0400, Terry Lee Tucker wrote: > we would have to use the [non-free] products above because > the customers demand calculations based on a commercial product. Are you saying that customers demand that you use a non-free product, or are you saying that customers demand a

Re: [GENERAL] Route Miles

2005-09-09 Thread Terry Lee Tucker
We use PCMiler and Rand McNally products, but they certainly aren't free. Both programs have good API's and run on Linux, which is of interest to us. We have the mileage lookup functionality integerated in to trigger code with C functions that do the work. I don't know of any free products. For