Examples of AvgWithArgumentCastFunction

org.hibernate.dialect.function.AvgWithArgumentCastFunction
Some databases strictly return the type of the of the aggregation value for AVG which is problematic in the case of averaging integers because the decimals will be dropped. The usual workaround is to cast the integer argument as some form of double/decimal. @author Steve Ebersole

Examples of org.hibernate.dialect.function.AvgWithArgumentCastFunction

      registerColumnType( Types.BLOB, "blob" );
      registerColumnType( Types.CLOB, "clob" );
    }


    // aggregate functions
    registerFunction( "avg", new AvgWithArgumentCastFunction( "double" ) );


    // string functions
    registerFunction( "ascii", new StandardSQLFunction( "ascii", StandardBasicTypes.INTEGER ) );
    registerFunction( "char", new StandardSQLFunction( "char", StandardBasicTypes.CHARACTER ) );
    registerFunction( "lower", new StandardSQLFunction( "lower" ) );

View Full Code Here

0 1 2 3 4 5

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.