Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 39939 invoked from network); 21 Nov 2005 18:44:31 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 21 Nov 2005 18:44:31 -0000 Received: (qmail 20264 invoked by uid 500); 21 Nov 2005 18:44:22 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 20231 invoked by uid 500); 21 Nov 2005 18:44:21 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 20222 invoked by uid 99); 21 Nov 2005 18:44:21 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 21 Nov 2005 10:44:21 -0800 Received-SPF: pass (asf.osuosl.org: local policy) Received: from [192.18.98.34] (HELO brmea-mail-3.sun.com) (192.18.98.34) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 21 Nov 2005 10:45:54 -0800 Received: from phys-d3-ha21sca-2 ([129.145.155.165]) by brmea-mail-3.sun.com (8.12.10/8.12.9) with ESMTP id jALIht3L019100 for ; Mon, 21 Nov 2005 11:44:00 -0700 (MST) Received: from conversion-daemon.ha21sca-mail1.sfbay.sun.com by ha21sca-mail1.sfbay.sun.com (iPlanet Messaging Server 5.2 HotFix 1.24 (built Dec 19 2003)) id <0IQB00F01IPER2@ha21sca-mail1.sfbay.sun.com> (original mail from Richard.Hillegas@Sun.COM) for derby-dev@db.apache.org; Mon, 21 Nov 2005 10:44:28 -0800 (PST) Received: from [129.144.89.176] (d-sfo07-89-176.SFBay.Sun.COM [129.144.89.176]) by ha21sca-mail1.sfbay.sun.com (iPlanet Messaging Server 5.2 HotFix 1.24 (built Dec 19 2003)) with ESMTP id <0IQB00GYOIQ42Z@ha21sca-mail1.sfbay.sun.com> for derby-dev@db.apache.org; Mon, 21 Nov 2005 10:44:28 -0800 (PST) Date: Mon, 21 Nov 2005 10:44:12 -0800 From: Rick Hillegas Subject: Re: [jira] Updated: (DERBY-499) Expose BOOLEAN datatype to end users In-reply-to: <7921d3e40511211038w5de0c5f4i866fd24ba7887c1c@mail.gmail.com> To: derby-dev@db.apache.org Message-id: <4382157C.5030107@sun.com> MIME-version: 1.0 Content-type: text/plain; charset=ISO-8859-1; format=flowed Content-transfer-encoding: 7BIT X-Accept-Language: en-us, en User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) References: <2015076743.1132591182460.JavaMail.jira@ajax.apache.org> <4381FD30.8030203@amberpoint.com> <4381FFF0.7060301@sun.com> <7921d3e40511210947t94e53fcu3dc6d78527a02d0b@mail.gmail.com> <43820F82.3040401@sun.com> <7921d3e40511211038w5de0c5f4i866fd24ba7887c1c@mail.gmail.com> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Hi Francois, I think what is puzzling you is the use of a single INSERT statement to poke two rows into the table. Each of the parenthisized lists after the VALUES keyword is actually a separate tuple. Putting each tuple on its own line might clarify this. Thanks, -Rick Francois Orsini wrote: > Ok thanks for the nullable clarification . > > I would not necessarily associate ANSI BOOLEAN datatype to > java.lang.Boolean one (different domains), but for the sake of this > clarification, it does work. > > The statement I mentioned is: > >INSERT INTO SAMPLE( boolCol ) VALUES ( true ), ( false ); > >There is only 1 column in the table - the VALUES clause shows 2 values...It may be that am not up-to-date on the latest SQL syntax ;) > >Thanks, > > >--francois > > > >