Re: [SQL] must appear in GROUP by clause issue

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

Re: [SQL] must appear in GROUP by clause issue

On Fri, Jun 29, 2012 at 4:02 PM, George Woodring 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, >              AVG(cpe

Re: [SQL] must appear in GROUP by clause issue

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 -- Ad

[SQL] must appear in GROUP by clause issue

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 d