Mike- Those functions require data of certain type, so your relational column would have to be converted to numeric for most of those anyway.
Creating a set of functions would get you there. You could then use comparison, numeric functions, etc and bonus-- 3rd party SQL tools. AB_INSERT() AB_SELECT_AS_DECIMAL() AB_SELECT_AS_LONG() AB_SELECT_AS_DOUBLE() etc. On Friday, August 7, 2020 at 10:21:58 AM UTC-5, Mike G wrote: > > Ok. Yes it was so things such as computation, comparison and other > conversions could work seemlessly. Obviously just storing the values is not > such a huge challenge. > > Probably the way you outline with the JavaObjectSerializer is the way to > go. In fact in my project I am more or less attempting to eliminate SQL, > and talk to the database directly so it may be possible to live without sql > support, but it will reduce quality of life given that it means all the SQL > based tools will no longer work so well. > > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/e0b544bc-5427-48b4-a4e2-185a85b334bco%40googlegroups.com.
