From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Hannu Krosing <hannu(at)tm(dot)ee> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Why Not MySQL? |
Date: | 2000-05-03 15:51:27 |
Message-ID: | 7884.957369087@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hannu Krosing <hannu(at)tm(dot)ee> writes:
> That's what I meant by introducing pushing the case-insensitiveness
> into ODBC,
I don't believe ODBC parses the query carefully enough to recognize
operators that would need to be altered to become case-insensitive.
I'm not even sure that it could do that --- does "WHERE f1 = f2"
need to be changed to "WHERE lower(f1) = lower(f2)"? No way to know
that unless you know the datatypes of f1 and f2, which would mean
(a) a moderately complete SQL parser/analyzer and (b) a copy of the
system catalogs inside ODBC. Doesn't sound like a promising avenue
of attack...
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Mount | 2000-05-03 15:59:39 | RE: RE: [HACKERS] Request for 7.0 JDBC status |
Previous Message | Tom Lane | 2000-05-03 15:43:39 | Re: 7.0RC2 compile error ! |