[ https://issues.jboss.org/browse/TEIIDDES-2213?page=com.atlassian.jira.plu... ] Mark Drilling edited comment on TEIIDDES-2213 at 11/12/14 6:52 PM: ------------------------------------------------------------------- On debugging designer code, I could see the column types all coming in as 'IN Parmeters' for the extended_foo procedure. Investigating further, I came across this - http://stackoverflow.com/questions/21541745/postgresql-9-jdbc-driver-retu... Here is a summary of parameter types for postgres 8.3 and 9.3 drivers for the 2 procs {noformat} procedure extended_foo coltype coltype name (8.3 driver) (9.3 driver) ------------------ ------- ----- pfooid 1 1 fooid 1 5 foosubid 1 5 fooname 1 5 procedure foo name (8.3 driver) (9.3 driver) ------------------ ------- ----- pfooid 1 1 fooid 3 3 foosubid 3 3 fooname 3 3 {noformat} coltype 1 = in parameter coltype 3 = procedure col result coltype 5 = procedure col return was (Author: mdrillin): On debugging designer code, I could see the column types all coming in as 'IN Parmeters' for the extended_foo procedure. Investigating further, I came across this - http://stackoverflow.com/questions/21541745/postgresql-9-jdbc-driver-retu... Here is a summary of parameter types for postgres 8.3 and 9.3 drivers for the 2 procs procedure extended_foo coltype coltype name (8.3 driver) (9.3 driver) ------------------ ------- ----- pfooid 1 1 fooid 1 5 foosubid 1 5 fooname 1 5 procedure foo name (8.3 driver) (9.3 driver) ------------------ ------- ----- pfooid 1 1 fooid 3 3 foosubid 3 3 fooname 3 3 coltype 1 = in parameter coltype 3 = procedure col result coltype 5 = procedure col return -- This message was sent by Atlassian JIRA (v6.3.8#6338)