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 it is a convention over configuration choice, as you can get both behaviours without having to use quotes. Michaël > 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 * from Def; > --select * from def; > > -- But if you write (in lower case) this works: > create table "ghi" ( id int ); > select * from ghi; > select * from Ghi; > select * from GHI; > > Please, can somebody test this with other DBMS? > > Thanks. > > Uwe > > ------------------------------------------------------------------------------ > Precog is a next-generation analytics platform capable of advanced > analytics on semi-structured data. The platform includes APIs for building > apps and a phenomenal toolset for data science. Developers can use > our toolset for easy data analysis & visualization. Get a free account! > http://www2.precog.com/precogplatform/slashdotnewsletter > _______________________________________________ > Jump-pilot-devel mailing list > Jump-pilot-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel > > ------------------------------------------------------------------------------ Precog is a next-generation analytics platform capable of advanced analytics on semi-structured data. The platform includes APIs for building apps and a phenomenal toolset for data science. Developers can use our toolset for easy data analysis & visualization. Get a free account! http://www2.precog.com/precogplatform/slashdotnewsletter _______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
