Re: [JPP-Devel] SQL test for tablenames

2013-04-14 Thread Michaƫl Michaud
Hi Uwe, Don't have experience with other databases, but your description seems to be consistent. It also means that from OpenJUMP you can : just use unquoted lower case identifiers if you want a case insensitive behaviour any case unquoted identifier for a case sensitive behaviour One can say i

[JPP-Devel] SQL test for tablenames

2013-04-11 Thread Uwe Dalluege
Hi, I have made some tests for tablenames in PostgreSQL. This works (name without delimiter): create table Abc ( id int ); select * from abc; select * from ABC; select * from abC; --- This causes problems: create table "Def" ( id int ); select * from "Def"; // this is ok! --Problems: --select *