Hi, Yes, it's basically the same as in Java, except that Java will not throw an exception on overflow but silently overflow. Automatically adjusting the data type depending on the operation is quite tricky.
Regards, Thomas On Thu, Nov 7, 2013 at 11:35 AM, Rami Ojares <[email protected]> wrote: > So did I understand this correctly? > You want to limit multiplication to Integer.MAX_INT even though you > support the type BIGINT? > And the reason for this is that PostgrSQL has the same limitation? > > - Rami > > > > PostgreSQL will get you the same results. See >> http://sqlfiddle.com/#!1/d41d8/1435 >> > > -- > 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 post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/groups/opt_out. > -- 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 post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
