postgresql extract used for date functions returns double, not integer ---------------------------------------------------------------------- Key: TEIID-3366 URL: https://issues.jboss.org/browse/TEIID-3366 Project: Teiid Issue Type: Bug Components: JDBC Connector Affects Versions: 7.7 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.11 Postgresql extract returns a double precision (which is documented as the expectation), but we expect integer values from the respective Teiid functions. This typically won't lead to an issue in a simple projection scenario, but is problematic for combined expressions, such as using mod which will result in an exception.