Re: The folding of unquoted names to lower case in

From: Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>
To: Andrew Sullivan <andrew(at)libertyrms(dot)info>, pgsql-general(at)postgresql(dot)org
Subject: Re: The folding of unquoted names to lower case in
Date: 2003-03-15 06:09:19
Message-ID: 5.1.0.14.1.20030315140539.02822ec0@mbox.jaring.my
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

At 01:50 PM 3/14/03 -0500, 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.

Yah, but following the SQL spec in that would violate my eyes :).

Would a compile time setting be easier to do than a GUC? Everything
unquoted folds up, and the system tables when doing initdb are all upper
case (UGH!).

That'll be fun to regression test tho ;).

Link.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Arunachalam Jaisankar 2003-03-15 06:38:45 How to change default date format?
Previous Message Lincoln Yeoh 2003-03-15 06:00:35 Re: type-casting and LIKE queries