seddonm1 commented on issue #935: URL: https://github.com/apache/arrow-datafusion/issues/935#issuecomment-905864071
I had a look at the postgres docs again and this implementation meets their definition (https://www.postgresql.org/docs/current/functions-string.html#id-1.5.8.10.7.2.2.2.1.1.1) importantly: ```removes the longest string containing only characters in characters``` which means characters is treated as an character array not a string literal Both postgres and datafusion implement consistently: ``` SELECT BTRIM('leadtrailtextleadtrail','leadtrail') 'x' ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
