This is still an Issue for me. When using SQLServer there is no MOD function but there is a % operator. How can I add this operator or do a workaround (other than doing a - (b * floor(a/b)))
Thanks, António Alegria On Wednesday, June 24, 2009 8:26:47 PM UTC+1, Jeremy Evans wrote: > > On Jun 24, 6:53 am, Bungenstock <[email protected]> wrote: > > Hi, > > why is NumericMethods reduced to +, -, *, and /. I am missing the > > modulo operator % and some others. > > No particular reason. I'd consider adding support depending on > database support. In terms of standards, I don't believe % is > supported as the modulo operator in SQL-92, but I'm not sure about > later versions. > > Many of the bitwise numeric methods are available in BitwiseMethods, > but Sequel has to know the expression is a number before it will allow > you to use those. You may need to call sql_number first. > > If you post some code and the SQL you want to generate, I'd probably > be more able to help. > > Thanks, > Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To view this discussion on the web visit https://groups.google.com/d/msg/sequel-talk/-/upPbCiRtY2AJ. 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/sequel-talk?hl=en.
