Hi, Note, I've found the semantics of TYPE_INFO.POS to be useful in my > use-case. It seems that I can probably ignore types with POS != 0. However, > that doesn't seem to be the correct way to handle this ambiguity > (especially, since I didn't find any documentation about POS)... >
DatabaseMetaData.getTypeInfo is supposed to return the best match first. The table TYPE_INFO is used internally in this method, and used 'order by data_type, pos'. So POS = 0 is the best match, but really this is database specific. I will add a new column TYPE_NAME to INFORMATION_SCHEMA.FUNCTION_ALIASES. Regards, Thomas -- 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.
