In PostGIS and Oracle, lpad('A', 5, 'x') produces 'xxxxA'. In the expression editor in QGIS, it produces 'Axxxx'. Similarly, rpad() adds extra characters to the left, while PostGIS and Oracle add ...