On Thu, Mar 6, 2014 at 8:41 PM, RSmith <rsm...@rsweb.co.za> wrote: > > On 2014/03/07 01:59, Gabor Grothendieck wrote: >> >> >>> >>>> >>>>> A small enhancement request: >>>>> >>>>> It would be great if the RPAD and LPAD functions could be implemented >>>>> in >>>>> sqlite. >>>>> >>>> The SQLite you can get the effect of RPAD(x,y) using PRINTF('%-*s',y,x). >>>> See http://www.sqlite.org/lang_corefunc.html#printf for details. >>> >>> Thanks, but you snipped the relevant part of my post: >>> "I know I can easily achieve the equivalent ... but if the functions were >>> available natively it would avoid the need to hack third party SQL scripts." >>> >> I have also found that it was tedious to retarget MySQL scripts to >> SQLite because many of the function calls are different. Its not just >> rpad and lpad but other functions too. > > > Speaking as someone who retargets (nice word btw.) SQL scripts often, yes I > agree, it's a bit of a chore to retarget SQL scripts to SQLite sometimes, > but not really moreso than retargeting a script from MSSQL to PostGres or
I have also retargeted MySQL scripts to H2 and it was easier than to SQLite. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users