db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kristian Waagan <Kristian.Waa...@Sun.COM>
Subject Re: Problem with Column Names
Date Mon, 07 Jun 2010 13:56:53 GMT
On 07.06.10 15:42, Mark Thornton wrote:
> On 07/06/2010 14:36, Brett Wooldridge wrote:
>> It is not valid in SQL to have column name (or other identifiers) 
>> that begin with a numeric character.  You're going to have to code 
>> specifically for this case.
> Quoted identifiers are (in standard SQL) permitted to be entirely 
> numeric.
> create table mytab ("393" decimal(3))
> should work.

This statement does work for me (tested on trunk), as does

ij> create table "999" ("393" decimal(3));

Are you sure you are quoting the identifier names correctly, both when 
creating and accessing them?
Also, are you created the tables/columns manually, or are you trying to 
use an import procedure?


View raw message