This was helpful, thank you. The issue was that one of the tables had a
name column added. Changing the alias name in the query so that it was
unique was the solution.
Thanks for the help,
George
On Sat, Jun 30, 2012 at 12:34 AM, Lee Hachadoorian
lee.hachadooria...@gmail.com wrote:
On Fri,
I have 2 (8.4.11) servers that I am testing the following query:
SELECT count(*),
maptrunc(cpeloc.lat, 4.5)::text || maptrunc(cpeloc.long,
4.5)::text AS name,
AVG(cpeloc.lat) AS lt,
AVG(cpeloc.long) AS lng
FROM cable_billing JOIN cpeloc USING(mac) LEFT JOIN
On 06/29/2012 01:02 PM, George Woodring wrote:
Any suggestions would be appreciated.
Are there any other errors before or after the above that might relate?
Are the function bodies the same on both servers?
George Woodring
--
iGLASS Networks
www.iglass.net http://www.iglass.net
--
On Fri, Jun 29, 2012 at 4:02 PM, George Woodring
george.woodr...@iglass.net wrote:
I have 2 (8.4.11) servers that I am testing the following query:
SELECT count(*),
maptrunc(cpeloc.lat, 4.5)::text || maptrunc(cpeloc.long,
4.5)::text AS name,
AVG(cpeloc.lat) AS lt,