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.
