Generate Sequences on Varchar column

marvinm

How do i generate sequences of data? It non-unique but sequential. The first 14 characters can be hardcoded, but the latter needs to be sequential, sum can be duplicates:
Hardcoded: 20170530183617
non-unique sequence:000000000000018855165,000000000000018855165 etc

20170530183617000000000000018855165
20170530183617000000000000018855169
20170530183617000000000000018855169
20170530183617000000000000018855173
20170530183617000000000000018855177
20170530183617000000000000018855177

Jessica R

Hi @marvinm,

If you create a Python script that uses a for loop to create the needed strings, and then return an iterable to print through that list, would that work?