Re: Route Miles

Terry,

How easy is it to get the route miles from one zip to another using with PCMiler or Rand McNally. Is it just a query on
some route table ie: select miles from route where zip1 = '11111' and zip2 = '22222'. Also do either of these cover Canada?

Thanks
Jim

---------- Original Message -----------
From: Terry Lee Tucker <terry(at)esc1(dot)com>
To: pgsql-general(at)postgresql(dot)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
> 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 and we have to use
> their data. The functionality is irrevelent to the customer. We simply use
> the mileage program whenever possible such that the mileages are
> automatically entered as the people in operations enter the freight records.
>
> On Friday 09 September 2005 10:40 am, Matt Miller saith:
> > 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 certain functionality that you
> > have found only in a non-free product?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
------- End of Original Message -------