Re: Aggregate function: Different results with jdbc and psql

From: "Marc Mamin" <M(dot)Mamin(at)intershop(dot)de>
To: "Tilman Rassy" <rassy(at)math(dot)TU-Berlin(dot)DE>, <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Aggregate function: Different results with jdbc and psql
Date: 2008-10-07 13:22:53
Message-ID: CA896D7906BF224F8A6D74A1B7E54AB3039E8BFB@JENMAIL01.ad.intershop.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Can you try modify your SQL to explicitely set the returned data type:

SELECT worksheet_id, user_id, num_edited, num_corrected, grade::float
FROM user_worksheet_grades
WHERE user_id = 23 AND worksheet_id = 105;

If this doesn't work too, than you can at least exclude a casting issue
...

cheers,

Marc

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Tilman Rassy 2008-10-07 14:57:10 Re: Aggregate function: Different results with jdbc and psql
Previous Message Tilman Rassy 2008-10-07 13:04:14 Re: Aggregate function: Different results with jdbc and psql