Re: SQL server application porting headache - Mailing list pgsql-general

From Tom Lane
Subject Re: SQL server application porting headache
Date
Msg-id 9030.1024850891@sss.pgh.pa.us
Whole thread Raw
In response to Re: SQL server application porting headache  (Oskar Berggren <beo@sgs.o.se>)
List pgsql-general
Oskar Berggren <beo@sgs.o.se> writes:
> Would it be difficult to make PostgreSQL case insensitive for real when
> comparing identifiers?

You could try altering the name comparison functions --- don't forget
the btree 3-way comparator, too.  And something would have to be done
with the hash function for names.  And I'm not sure what else; but I
suspect there are a lot of strcmp() calls that would have to be changed.

Curt Sampson remarks nearby that he doesn't believe SQL Server acts
the way you suggest.  Are you sure you have diagnosed your problem
correctly?

            regards, tom lane

pgsql-general by date:

Previous
From: Curt Sampson
Date:
Subject: Re: SQL server application porting headache
Next
From: Francisco Reyes
Date:
Subject: Re: website design