Note: migrated from original JIRA: https://issues.apache.org/jira/browse/ARROW-11164
apache/arrow#9108 adds the ltrim and rtrim functions to datafusion, following postgres. However, postgres offers a second optional argument (the character to trim) that is not yet implemented, as described on https://www.postgresql.org/docs/9.1/functions-string.html
For example:
!103891510-f84d8800-50b7-11eb-929e-94f56c2364cd.png!
This ticket tracks the work to add support for the second optional arguments (what character to trim) - it would probably be a good introductory item for new contributors.
There is more context here:
apache/arrow#9108 (review)