Re: Cant group by non integer - ms access - odbc - Mailing list pgsql-novice

From Ludwig Lim
Subject Re: Cant group by non integer - ms access - odbc
Date
Msg-id 20021218123415.58784.qmail@web80311.mail.yahoo.com
Whole thread Raw
In response to Cant group by non integer - ms access - odbc  (Glenn <glenn@pip.com.au>)
Responses Re: Cant group by non integer - ms access - odbc
List pgsql-novice
Hi Glenn,

--- Glenn <glenn@pip.com.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

pgsql-novice by date:

Previous
From: Glenn
Date:
Subject: Cant group by non integer - ms access - odbc
Next
From: Glenn
Date:
Subject: Re: Cant group by non integer - ms access - odbc