Re: Aggregate function: Different results with jdbc and psql

From: Guillaume Cottenceau <gc(at)mnc(dot)ch>
To: Tilman Rassy <rassy(at)math(dot)TU-Berlin(dot)DE>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Aggregate function: Different results with jdbc and psql
Date: 2008-10-07 12:01:56
Message-ID: 878wt01umj.fsf@mnc.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Tom Lane 2008-10-07 12:21:01 Re: Aggregate function: Different results with jdbc and psql
Previous Message Tilman Rassy 2008-10-07 11:26:56 Aggregate function: Different results with jdbc and psql