Skip site navigation (1) Skip section navigation (2)

Re: Cant group by non integer - ms access - odbc

From: Glenn <glenn(at)pip(dot)com(dot)au>
To: Ludwig Lim <lud_nowhere_man(at)yahoo(dot)com>
Cc: PostgreSQL Mailing List <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Cant group by non integer - ms access - odbc
Date: 2002-12-18 14:47:28
Message-ID: 1040222848.26812.16.camel@thor.valhalla (view raw or flat)
Thread:
Lists: pgsql-novice
Hi Ludwig
Seems I've actually asked the wrong q...
My query was something like

"SELECT f1,f2,count(f3) as countOff3, sum(f4) as countoff4,f5,"-" as f6 
FROM mytable
GROUP BY f1,f2,f5,"-""

Once I took out everything to do with f6, then it worked - however I
need f6, as this forms a select to be inserted into another table. So
now my question should be what is the postgres equivalent to this?
Thanks
Glenn

On Wed, 2002-12-18 at 23:34, Ludwig Lim wrote:
> Hi Glenn,
> 
> --- Glenn <glenn(at)pip(dot)com(dot)au> wrote:
> > I'm trying an aggregate query with groupby's on text
> > fields. As per
> > various FAQ's I have text fields NOT mapped to
> > LongVARCHAR in the odbc
> > dsn - but I get an error when I try an view the
> > query --(cut from
> > log)--> " message='ERROR:  Non-integer constant in
> > GROUP BY' "
> > 
> > Any clues??
> 
>   What is your query (i.e. sql statement)? Can you
> give me the sturcture of the table(s) you are
> querying?
> 
> ludwig
> 
> 
> __________________________________________________
> Do you Yahoo!?
> New DSL Internet Access from SBC & Yahoo!
> http://sbc.yahoo.com
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
-- 
Glenn <glenn(at)pip(dot)com(dot)au>


In response to

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2002-12-18 15:47:55
Subject: Re: how to traverse a bytea value in pl/pgsql
Previous:From: Ludwig LimDate: 2002-12-18 12:34:15
Subject: Re: Cant group by non integer - ms access - odbc

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group