Can someone show me the case specifications for SQL?

I think that unless quoted table names are case insensitive, so

  SELECT * FROM FOO;

equals

  select * from foo;

but does not equal

  SELECT * from "Foo";

IMHO, when selecting from files, unquoted table names should match
case-insensitive, so a file named "Foo" should match all three, but
file named "foo" should match the first two statements.

If I am right, I got the unquoted working in my current DBD::File,
and I'm working on the second part (it currently matches too often)

-- 
H.Merijn Brand  http://tux.nl      Perl Monger  http://amsterdam.pm.org/
using & porting perl 5.6.2, 5.8.x, 5.10.x, 5.11.x on HP-UX 10.20, 11.00,
11.11, 11.23, and 11.31, OpenSuSE 10.3, 11.0, and 11.1, AIX 5.2 and 5.3.
http://mirrors.develooper.com/hpux/           http://www.test-smoke.org/
http://qa.perl.org      http://www.goldmark.org/jeff/stupid-disclaimers/

Reply via email to