Re: Aggregate function: Different results with jdbc and psql

On Tuesday 07 October 2008 14:48, Marc Mamin wrote:
> maybe you try to retrieve the value of grade with an inappropriate
> method ?

I use the getFoat Method. Here is the code:

// Query grade data:
float result = 0;
ResultSet gradeData = dbHelper.queryUserWorksheetGrade(userId, worksheetId);
if ( !gradeData.next() )
  this.logDebug("### DEBUG 1 ### Result set empty");
else
  {
    result = gradeData.getFloat(DbColumn.GRADE);
    if ( gradeData.wasNull() )
      this.logDebug("### DEBUG 2 ### Column was SQL NULL");
  }

In the logs I see: "### DEBUG 2 ### Column was SQL NULL"

In earlier tries, I experimented with different types for "result" (double,
String). I also casted on the SQL side to "double precision" before
multiplying und summing. No effect.