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

From: Ludwig Lim <lud_nowhere_man(at)yahoo(dot)com>
To: Glenn <glenn(at)pip(dot)com(dot)au>
Cc: PostgreSQL Mailing List <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Cant group by non integer - ms access - odbc
Date: 2002-12-18 12:34:15
Message-ID: 20021218123415.58784.qmail@web80311.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Glenn 2002-12-18 14:47:28 Re: Cant group by non integer - ms access - odbc
Previous Message Glenn 2002-12-18 12:24:15 Cant group by non integer - ms access - odbc