Hello,

I have created a user-defined function with a ResultSet return type,
as documented here:
http://www.h2database.com/html/features.html#user_defined_functions

When I try to look up this function in
select * from information_schema.function_aliases

I get DATA_TYPE = 0, which maps to the JDBC type java.sql.Types.NULL.
This is the same as for functions that have a void return type, where
NULL makes sense. However, NULL or DATA_TYPE 0 is not listed in
select * from information_schema.type_info

Is that intentional? (note that the Oracle JDBC driver uses
OracleTypes.CURSOR = -10 for this. This is not a JDBC standard
though).

Cheers
Lukas

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.

Reply via email to