db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Francois Orsini <francois.ors...@gmail.com>
Subject Re: [jira] Updated: (DERBY-499) Expose BOOLEAN datatype to end users
Date Mon, 21 Nov 2005 18:47:47 GMT
Yep - not a problem tho...

Thanks Rick

On 11/21/05, Rick Hillegas <Richard.Hillegas@sun.com> wrote:
>
> 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
> >
> >
> >
> >
>
>

Mime
View raw message