Path: csiph.com!news.mixmin.net!aioe.org!.POSTED!not-for-mail
From: "Dr.UgoGagliardelli" <do.not.spam@me.please>
Newsgroups: it.comp.java
Subject: Re: hsql
Date: Sat, 17 Oct 2015 06:51:21 +0200
Organization: Aioe.org NNTP Server
Lines: 23
Message-ID: <mvsk4d$u71$1@speranza.aioe.org>
References: <mvravk$tfs$1@speranza.aioe.org> <26a0731b-202e-4e1d-a411-c13b0b3298ab@googlegroups.com> <mvs0ft$jt5$2@speranza.aioe.org> <977f6ee8-9c7d-450a-851d-7335db94e10e@googlegroups.com>
NNTP-Posting-Host: w5/KoasfCEasm7WubpjmBw.user.speranza.aioe.org
Mime-Version: 1.0
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 8bit
X-Complaints-To: abuse@aioe.org
User-Agent: Mozilla/5.0 (Windows NT 6.3; WOW64; rv:38.0) Gecko/20100101 Thunderbird/38.3.0
X-Notice: Filtered by postfilter v. 0.8.2
Xref: csiph.com it.comp.java:8634

Il 17.10.2015 01.24, 4ndre4 ha scritto:
> On Saturday, 17 October 2015 00:16:15 UTC+1, Gulp®  wrote:
>
> [...]
>> D'altra parte la guida indica la sintassi \"fornitori\" come corretta.
>
> Secondo http://www.hsqldb.org/doc/guide/ch09.html#select-section,
> il nome della tabella non vuole i doppi apici (che, comunque, non sono SQL standard).
Questo non e' vero i doppi apici sono ammessi, almeno fin dallo standard 
SQL92.
D'altra parte nel link che hai indicato, specifico per hsqldb, ad un 
certo punto dice: (cito)

Quoted identifiers can be used as names (for tables, columns, 
constraints or indexes). Quoted identifiers start and end with " (one 
doublequote). A quoted identifier can contain any Unicode character, 
including space. In a quoted identifier use "" (two doublequotes) to 
create a " (one doublequote). With quoted identifiers it is possible to 
create mixed-case table and column names. Example:

     CREATE TABLE "Address" ("Nr" INTEGER,"Name" VARCHAR);
     SELECT "Nr", "Name" FROM "Address";