Skip to content

Support for ANSI SQL syntax in TRIM function #28362

Description

@nishithakbhaskaran

Expected Behavior or Use Case

Support the below syntax in trim function

TRIM(BOTH | LEADING | TRAILING FROM <source>)
TRIM(BOTH | LEADING | TRAILING <char> FROM <source>)
TRIM(<source>, <char>)   -- existing comma form, unchanged

Presto Component, Service, or Connector

Possible Implementation

Example Screenshots (if appropriate):

Context

Metadata

Metadata

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions