db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <Richard.Hille...@Sun.COM>
Subject Re: [jira] Updated: (DERBY-499) Expose BOOLEAN datatype to end users
Date Mon, 21 Nov 2005 18:44:12 GMT
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