| From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
|---|---|
| To: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: The folding of unquoted names to lower case in PostgreSQL |
| Date: | 2003-03-14 19:12:14 |
| Message-ID: | Pine.LNX.4.33.0303141210220.23870-100000@css120.ihs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 14 Mar 2003, Andrew Sullivan wrote:
> On Wed, Mar 12, 2003 at 10:30:19AM -0700, scott.marlowe wrote:
> > It's a hackish kluge, but not as big of one as what MapInfo would appear
> > to be :-)
>
> To be fair, the SQL spec requires that unquoted strings be folded to
> upper case, so it's really PostgreSQL's violation of the spec that is
> biting here.
True, very true. While mapinfo would be better had they picked one case /
quoting methodology and stuck to it, the lack of a fold_to_upper setting
or something similar in postgresql is a glaring flaw givin that folding to
lower is against spec, not just doing something a certain way because no
one bothered to define it.
Any chance a patch to set a GUC for case folding would get applied?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | valerian | 2003-03-14 19:15:23 | Re: type-casting and LIKE queries |
| Previous Message | Andrew Sullivan | 2003-03-14 18:50:57 | Re: The folding of unquoted names to lower case in PostgreSQL |