From: | Nuchanach Klinjun <nuchk(at)inet(dot)co(dot)th> |
---|---|
To: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Returned Result via ODBC! |
Date: | 1999-09-29 03:31:00 |
Message-ID: | Pine.OSF.4.10.9909291030370.25094-100000@johann.inet.co.th |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Dear Sir,
I got your email address from the file notice.txt of pub/odbc/
I've problem with getting output from database via ODBC
my query is -->
select s.account,sum(dround(date_part('epoch',s.stop-s.start)/36.0)/100) as
usage,sum(date_part('epoch',s.stop-s.start)/3600*s.rate/t.rate) as charge
from session s,ticket t
where s.stop >= '1999/06/10' and s.stop < '1999/06/21' and
s.ticket = t.id and not t.free and s.nas = '203.151.66.7' group by
s.account;
I use MS Access 97 as frontend application and
ODBC : postodbc 6.4.7
Database : PostgreSQL 6.5.1 on i386-unknown-freebsd2.2.8, compiled by cc
I sent the passthrough query to the postgres backend. it always
return only the first field and the second (account,usage). and I noticed
that the backend always return only some other fields and only 1 sum field
(it's wierd).
with the same query I tried run it on the database promt it return
the complete result.
Please help.
Regards,
-----------------------------------------
Nuchanach Klinjun
R&D Project. Internet Thailand
Email: nuchk(at)inet(dot)co(dot)th
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Lockhart | 1999-09-29 04:41:26 | Re: RI and PARSER (was: Re: [HACKERS] RI status report #1) |
Previous Message | The Hermit Hacker | 1999-09-29 02:27:23 | Re: [HACKERS] MS Access upsizing |