Return-Path: 
 <derby-dev-return-39640-apmail-db-derby-dev-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-derby-dev-archive@www.apache.org
Received: (qmail 9828 invoked from network); 27 Mar 2007 21:30:58 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 27 Mar 2007 21:30:58 -0000
Received: (qmail 47385 invoked by uid 500); 27 Mar 2007 21:31:05 -0000
Delivered-To: apmail-db-derby-dev-archive@db.apache.org
Received: (qmail 47363 invoked by uid 500); 27 Mar 2007 21:31:05 -0000
Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:derby-dev-help@db.apache.org>
List-Unsubscribe: <mailto:derby-dev-unsubscribe@db.apache.org>
List-Post: <mailto:derby-dev@db.apache.org>
List-Id: <derby-dev.db.apache.org>
Reply-To: <derby-dev@db.apache.org>
Delivered-To: mailing list derby-dev@db.apache.org
Received: (qmail 47350 invoked by uid 99); 27 Mar 2007 21:31:04 -0000
Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 27 Mar 2007 14:31:04 -0700
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=UNPARSEABLE_RELAY
X-Spam-Check-By: apache.org
Received-SPF: pass (herse.apache.org: local policy)
Received: from [192.18.1.36] (HELO gmp-ea-fw-1.sun.com) (192.18.1.36)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 27 Mar 2007 14:30:56 -0700
Received: from d1-emea-10.sun.com (d1-emea-10.sun.com [192.18.2.120])
	by gmp-ea-fw-1.sun.com (8.13.6+Sun/8.12.9) with ESMTP id l2RLUYRp002382
	for <derby-dev@db.apache.org>; Tue, 27 Mar 2007 21:30:35 GMT
Received: from conversion-daemon.d1-emea-10.sun.com by d1-emea-10.sun.com
 (Sun Java System Messaging Server 6.2-6.01 (built Apr  3 2006))
 id <0JFK00M01ZE5PW00@d1-emea-10.sun.com>
 (original mail from Dag.Wanvik@Sun.COM) for derby-dev@db.apache.org; Tue,
 27 Mar 2007 22:30:34 +0100 (BST)
Received: from khepri05.norway.sun.com ([129.159.112.194])
 by d1-emea-10.sun.com
 (Sun Java System Messaging Server 6.2-6.01 (built Apr  3 2006))
 with ESMTPSA id <0JFK009KWZQYBN20@d1-emea-10.sun.com> for
 derby-dev@db.apache.org; Tue, 27 Mar 2007 22:30:34 +0100 (BST)
Date: Tue, 27 Mar 2007 23:30:33 +0200
From: Dag.Wanvik@Sun.COM (Dag H. Wanvik)
Subject: Re: [jira] Commented: (DERBY-1623) Add ANSI TRIM implementation
In-reply-to: <27245912.1175016572640.JavaMail.jira@brutus>
Sender: Dag.Wanvik@Sun.COM
To: derby-dev@db.apache.org
Message-id: <x1ox4po6e5mu.fsf@sun.com>
MIME-version: 1.0
Content-type: text/plain; charset=us-ascii
Content-transfer-encoding: 7BIT
References: <27245912.1175016572640.JavaMail.jira@brutus>
User-Agent: Gnus/5.1008 (Gnus v5.10.8) Emacs/22.0.50 (usg-unix-v)
X-Virus-Checked: Checked by ClamAV on apache.org

"Manish Khettry (JIRA)" <jira@apache.org> writes:

>     [ https://issues.apache.org/jira/browse/DERBY-1623?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12484510 ] 
>
> Manish Khettry commented on DERBY-1623:
> ---------------------------------------
>
> Yes, I agree the better thing to do is to implement the sql standard and leave ltrim/rtrimalone. 
>
> I don't have ready access to the sql standard so I'm a litlle unsure
          ***

I found this link which contains a version of 2003 which is very close
("an almost indistinguishable delta") to the final product,
apparently:

http://www.wiscorp.com/SQLStandards.html
http://www.wiscorp.com/sql_2003_standard.zip

Maybe this is useful for some people :)

Dag

> about the <trim character>. I'm taking it as a string
> literal. Looking at this page,
> http://www.oreilly.com/catalog/sqlnut/chapter/ch04.html, it looks
> like, it is interpreted as a string that needs to be removed. i.e.

>
> trim(leading 'ab' from 'bac') => bac
> trim(leading 'ba' from 'bac') => c
>
> and not as I'd thought earlier a set of characters to be removed.
>
>
>
>> 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.
>

-- 
Dag H. Wanvik
Sun Microsystems, Database Technology Group (DBTG)
Haakon VII gt. 7b, N-7485 Trondheim, Norway
Tel: x43496/+47 73842196, Fax:  +47 73842101