Hi, In the current state of H2 1.4.17, there is no way to retrieve procedure return type. However JDBC Api of DataBaseMetaData#getProcedureColumns specify that *ORDINAL_POSITION* at 0 mean return value of procedure. PostGreSQL follow JDBC Api for this point.
Here the patch in order to return the return type of procedures: https://github.com/nicolas-f/H2-Mirror/compare/meta_procedures https://github.com/nicolas-f/H2-Mirror/compare/meta_procedures.diff https://github.com/nicolas-f/H2-Mirror/compare/meta_procedures.patch There is some duplicated lines in the patch. I prefer to leave it as is for the sake of diff clarity. I would like to see the patch applied to 1.3.X but as SVN does not support branch it is impossible.. Thanks for support. Best regards, Nicolas Fortin, RISING FR IRSTV 2488 -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.