db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Thornton <mthorn...@optrak.co.uk>
Subject Re: Problem with Column Names
Date Mon, 07 Jun 2010 13:42:38 GMT
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.


Mime
View raw message