Re: Aggregate function: Different results with jdbc and psql - Mailing list pgsql-jdbc

Tilman Rassy <rassy 'at' math.TU-Berlin.DE> writes:

> 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.

Can you show the Java code (to the list)?

Are you sure you connect to the database with the same
user/password with psql and JDBC?

--
Guillaume Cottenceau