Thanks guys, That pretty much answers my questions. No there is not an easy way. While the access to a lot of internals to the postgresql database can be advantages it is exactly the kind of thing to break generic code anytime something changes. I think I'll take the harder approach and stick with the standard defined interfaces in java.sql. Did I read this in the manual somewhere? :)
MySQLView Project Manager Dana Proctor ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match