db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "A B (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-1623) Add ANSI TRIM implementation
Date Mon, 26 Mar 2007 22:58:32 GMT

    [ 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.

View raw message