Regina Obe: Substring function Regex style 🚀 Unleashing the Regex Sorcery with PostgreSQL's Substring Function! 🔍 Hey there, PostgreSQL enthusiasts! Ever dust off that old code and discover a gem ...
-- -- 1234567 -- SELECT 'ABCDEFG' AS original -- ABCDEFG -- --- rightmost 3 characters --- , SUBSTRING('ABCDEFG', 4) AS wrong_1 -- DEFG -- , SUBSTRING('ABCDEFG', 5 ...
library(dbplyr) translate_sql(substring('abcdefghijklmno', 6,7)) #> Expected: <SQL> substring('abcdefghijklmno', 6, 7) #> Actual: <SQL> substring('abcdefghijklmno', 6 ...