How to emulate REPEAT() in SQLite

Most relational databases have some sort of REPEAT() string function, for instance:

REPEAT()

SELECT REPEAT('abc', 3)

Would yield

abcabcabc

SQLite on the other hand has a very limited feature set. The functions supported by SQLite are listed here:

http://www.sqlite.org/lang_corefunc.html

Can REPEAT() be emulated with the functions available in SQLite?

REPEAT()

2 Answers
2

A simplified version of @Lukas Eder's solution using hex() instead of quote:

-- X = string -- Y = number of repetitions replace(hex(zeroblob(Y)), '00', X)

A solution was inspired by this answer to a related question, here:

How to simulate LPAD/RPAD with SQLite

I wanted to share this on Stack Overflow, as this may be useful to other SQLite users. The solution goes like this:

-- X = string -- Y = number of repetitions replace(substr(quote(zeroblob((Y + 1) / 2)), 3, Y), '0', X)

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

搜尋此網誌

Sfyjdyy