Hi Thomas, I am curious about this as well. We have been extending our UDT support in jOOQ (http://jooq.sourceforge.net). Mainly Oracle and Postgres databases prove to provide interesting implementations of user defined types. While it is unclear, whether their use is interesting in tables to a broad public, they can be very helpful for stored procedures, when you have complex parameters or return values of a well-defined type. Also, the DB2 database has support for UDT's but it is very limited and complicated.
If you are going to add UDT support to the H2 database, let me know. I'll happily implement a generic support for it in jOOQ as well. Cheers Lukas On 29 Nov. 2010, 14:15, ArturoMS <[email protected]> wrote: > Hi Thomas: > Postgresql support composite types, anyway i found another path for > solve my problem. (derived all from object-relational impedance > mismatch) > after hours, i believe that is no important. > select (1,'hola amigos') works in many situations. > Thanks for you response > On 28 nov, 11:43, Thomas Mueller <[email protected]> wrote: > > > Hi, > > > > h2 will support Composite types like my type (id integer, value > > > varchar(40)); > > > No. Why do you need it, and what databases support it? I can add a > > feature request for it, but I don't think it will be supported in the > > near future. > > > By the way, not sure if that's related, the ARRAY data type does > > support different data types for each element: > > > select (1, 'Hello') as comp; > > > 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.
