You should be able to use the any value as the object type. This issue was addressed with a fix under the https://issues.jboss.org/browse/TEIID-1011 JIRA. See http://source.jboss.org/browse/Teiid/trunk/common-core/src/main/java/org/teiid/core/types/DataTypeManager.java#3094. That fix is in 7.4 or later.
With that fix, you can use those objects as they are returned from PG. As for adding a native type for InetAddresses, that is something that could be requested through a JIRA. I don't think we've had it come up before now.
Thanks for your prompt response. I will try to pull down the 7.4 baseline and try again. Thanks again for your assistance. Take care.
P.S. I'm sure I will have a lot more questions in the not so distant future as we start utilizing Teiid more.
O.k., I've attempted to migrate from Teiid 7.3 to 7.4 to no avail thus far. I've found a lot of the dependent jar files within the JBoss distribution under "deployers/teiid.deployer/" (such as the engine, core api, and runtime) After removing all my 7.3 associations and replacing them with 7.4; creating a brand new JBoss 5.1.0 with a Teiid 7.4 overlay; and redeploying all the VDBs and their dependencies I get a NullPointerException thrown when in org.teiid.query.sql.navigator.DeepPreOrderNavigator's doVisit method. where it tries to call acceptVisitor on a LanguageObject that is passed into the doVisit method. Unfortunately, this object is null for one of the calls. I haven't had a lot of time to fully debug this to see what mapping object is having issues (I will be spending a little time doing that now.) The pertinent portion of the stacktrace is as follows:
Caused by: java.lang.NullPointerException
... 39 more
The first part of the stacktrace doesn't seem useful: Unexpected exception for request <request id> nullnull
Something weird must have been going on behind the scenes (JBoss, Teiid, not really sure.) After deleting the view model and rebuilding it from the XSD, I was able to successfully run against Teiid 7.4 on a PostgreSQL INET column (converting it into a string.) It seemed like the NPE (null pointer exception) was thrown when it encountered it's first convert statement, can't validate this, but, this is what it appeared to be when I debugged the Teiid server instance when the problem was still occurring. Thanks for your assistance.