yah, that's true... thanks Matt! On Thursday, July 23, 2020 at 6:35:31 PM UTC+3, Matt Pavlovich wrote: > > "auto" is going to be subjective because JSON types aren't 1:1 to SQL > types for number precision. To retain precision in JSON, one is forced to > store those values as strings instead of numbers. > > ref: https://www.w3schools.com/js/js_numbers.asp > > On Thursday, July 23, 2020 at 9:27:20 AM UTC-5, George Ivanov wrote: >> >> yes, however, I'd like the types to be automatically preserved from the >> original JSON types. >> I don't want to manually populate the types. Instead I'd like, for >> example, to analyze the datatypes from JSON but in the H2 DB using SQL >> >
-- 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/62bb2496-212c-4b93-a3e8-b46a05e6493co%40googlegroups.com.
