Re: SQL server application porting headache

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Oskar Berggren <beo(at)sgs(dot)o(dot)se>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: SQL server application porting headache
Date: 2002-06-23 16:48:11
Message-ID: 9030.1024850891@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Oskar Berggren <beo(at)sgs(dot)o(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Francisco Reyes 2002-06-23 16:51:13 Re: website design
Previous Message Curt Sampson 2002-06-23 16:37:44 Re: SQL server application porting headache