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?
Regards,
--
Kristian
