'Math' Tag

  • Monotonic functions, SQL and MySQL

    February 9, 2010

    In mathematics, a monotonic function (or monotone function) is a function which preserves the given order. [Wikipedia]
    To be more precise, a function f is monotonic increasing, if for every x ≤ y it holds that f(x) ≤ f(y). f is said to be strictly monotonic increasing is for every x < y it holds that f(x) [...]

  • Checking for string permutation

    January 20, 2010

    A permutation is a change of places. Thus, ‘lolhe’ is a permuted ‘hello’ (commonly referred to as ’scrambled text’).
    I wish to present an SQL solution for checking if two strings are permutations of the same text.
    About permutations
    So, if ‘lolhe’ is a permutation of ‘hello’, then ‘hello’ is a permutation of ‘lolhe’, as well; and both [...]

 
Powered by Wordpress and MySQL. Theme by openark.org