On Thu, Mar 6, 2014 at 6:29 PM, Walter Hurry <walterhu...@gmail.com> wrote:
> Richard Hipp wrote:
>
>> On Thu, Mar 6, 2014 at 3:41 PM, Walter Hurry <walterhu...@gmail.com> 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.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
