- From: Richard Cyganiak <richard@cyganiak.de>
- Date: Mon, 8 Aug 2011 11:57:18 +0100
- To: Nuno Lopes <nuno.lopes@deri.org>
- Cc: W3C RDB2RDF <public-rdb2rdf-wg@w3.org>
On 5 Aug 2011, at 22:17, Nuno Lopes wrote:
> 2) the SQL scripts to create the databases use double quoted strings ("string"). PostgreSQL seems to have a problem with this and expect single quoted strings ('string'), MySQL seems to work with either representation. What the standard for representing strings? Should we use single quotes if it works on more SQL engines?
Single quotes are standard SQL for enclosing string literals.
In standard SQL, double quotes are reserved for quoting *identifiers* such as column and table names.
This is a standard SQL query:
SELECT "ID" FROM "EMP" WHERE "NAME"='Bob'
See the note at [1] for more details on quoting of identifiers.
Best,
Richard
[1] http://www.w3.org/2001/sw/rdb2rdf/r2rml/#dfn-sql-identifier
Received on Monday, 8 August 2011 10:57:50 UTC