[
https://issues.apache.org/jira/browse/DERBY-1623?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12484255
]
A B commented on DERBY-1623:
----------------------------
> I'm thinking of adding an optional argument to the existing LTRIM and RTRIM
> functions. This will
> be a string literal and is basically the set of chars to trim.
I'm assuming this new functionality is defined by the SQL standard, but I'm not
familiar enough with said standard to find it (I couldn't even find LTRIM or
RTRIM). Can you point me to the relevant sections of the relevant spec? Sorry
for my ignorance here...
> Add ANSI TRIM implementation
> ----------------------------
>
> Key: DERBY-1623
> URL: https://issues.apache.org/jira/browse/DERBY-1623
> Project: Derby
> Issue Type: Improvement
> Components: SQL
> Reporter: Emmanuel Bernard
> Assigned To: Manish Khettry
>
> JPA is requiring databases to support this ANSI feature esp the ability to
> chose the trimmed character
> TRIM([ [ LEADING | TRAILING | BOTH ] [ chars ] FROM ] str)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
