Hi, DATABASE_TO_UPPER: it would be really nice if the type declaration / usage would also work as expected. At some point (but not in the near future, maybe H2 version 2.0) I would like to make DATABASE_TO_UPPER the default. Patches are welcome of course!
Regards, Thomas On Mon, Jul 16, 2012 at 8:36 AM, Christopher Deckers <[email protected]> wrote: > Hi Remi, > >> Domain is the sql term for type >> That's the concept around which custom types and inheritance should be >> built. > > Thanks, declaring my own type is an improvement already: > CREATE DOMAIN MYOBJECT AS OTHER > >> If the DBMS already supports the basic types like "list of characters", >> "integers", "list of bytes", boolean etc. >> Then all other types can be derived (inherited) from those basic types using >> constraints on the set of values of the parent type. > > But there is no composition (struct) so OTHER to the rescue. > > > By-the-way, my first attempt failed. > I have "DATABASE_TO_UPPER" set to "FALSE", so I naturally thought I could do: > CREATE DOMAIN MyObject AS OTHER > but then this statement failed: > CREATE TABLE "MyTable" (AnObject MyObject) > > I also tried without success: > CREATE DOMAIN "MyObject" AS OTHER > CREATE TABLE "MyTable" (AnObject "MyObject") > > I understand that case sensitivity is special, and for the type > declaration this is mostly internal so I can use an all-caps form. I > just wanted to let you know my findings. > > Cheers, > -Christopher > > -- > 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. > -- 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.
