Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group