Hello,
maybe you try to retrieve the value of grade with an inappropriate
method ?
What are the data types returned with psql ?
HTH,
Marc Mamin
-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Tilman Rassy
Sent: Tuesday, October 07, 2008 1:27 PM
To: pgsql-jdbc@postgresql.org
Subject: [JDBC] Aggregate function: Different results with jdbc and psql
Hello,
I have the following problem: A certain query, i.e.,
SELECT * FROM user_worksheet_grades WHERE user_id = 23 AND worksheet_id
= 105;
gives
worksheet_id | user_id | num_edited | num_corrected | grade
--------------+---------+------------+---------------+-------
105 | 23 | 1 | 1 | 4
(1 row)
when I issue it in psql. When I use the same query from JDBC in Java,
the column "grade" is SQL NULL.
The table "user_worksheet_grades" is actually a view which gets its data
from two other views, one of which is defined as follows:
SELECT
wks.id AS worksheet_id,
ann.the_user AS user_id,
count(ann.ann_type) AS num_corrected,
sum(ref_wks_prb.points * ann.score) AS grade FROM latest_worksheets
wks, refs_worksheet_generic_problem ref_wks_prb,
anns_user_worksheet_generic_problem ann WHERE ann.ref = ref_wks_prb.id
AND ref_wks_prb.from_doc = wks.id AND ann.ann_type = 2 GROUP BY wks.id,
ann.the_user;
Thus, "grade" is defined as a sum of products.
I use PostgreSQL 8.2.3 on Linux.
Any help will be appreciated!
Tilman
--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org) To make
changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc