Criteria casting.

Sheldon Ross <[email protected]> Mon, 12 Oct 2009 16:23:42 -0600
Newsgroups gmane.comp.jakarta.turbine.torque.user
Message-ID <[email protected]>
So I have

Criteria subquery = new Criteria();
criteria.add(ThisObjectPeer.COLUMN_A,valueA);
criteria.addSelectColumn(ThisObjectPeer.COLUMN_B);

Criteria criteria = new Criteria();
criteria.add(TheOtherObjectPeer.COLUMN_C,subquery,Criteria.IN);


The only problem is COLUMN_B is an string, and COLUMN_C is an integer. 
Is there any way to add a cast in the subquery, or select column as an 
integer?

The new versions of Postgresql strongly enforce types and won't let you 
compare integer to character varying.

Any thoughts?
Thanks

-- 
Sheldon Ross
Software Development