GitHub

PostgreSQL Substring.md

-- -- 1234567 -- SELECT 'ABCDEFG' AS original -- ABCDEFG -- --- rightmost 3 characters --- , SUBSTRING('ABCDEFG', 4) AS wrong_1 -- DEFG -- , SUBSTRING('ABCDEFG', 5 ...
GitHub

Postgres: substring generates numeric arguments instead of integer

library(dbplyr) translate_sql(substring('abcdefghijklmno', 6,7)) #> Expected: <SQL> substring('abcdefghijklmno', 6, 7) #> Actual: <SQL> substring('abcdefghijklmno', 6 ...