Skip site navigation (1) Skip section navigation (2)

Re: Case-Insensitve Text Comparison

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>
Cc: "David E(dot) Wheeler" <david(at)kineticode(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Case-Insensitve Text Comparison
Date: 2008-06-03 20:53:56
Message-ID: 1212526436.31688.18.camel@dogma.ljc.laika.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Tue, 2008-06-03 at 21:26 +0200, Zdenek Kotala wrote:
> The first step is per database, because it is relative easy. Collation 
> per-column is very difficult. It requires a lot of changes (parser, planer, 
> executor...) in whole source code, because you need to keep collation 
> information together with text data.

Right now typmod is already passed to all those layers, right? Would it
be a useful intermediate step to use typmod to hold this information for
the text type?

I suppose that would only work for text and not varchar, because varchar
already has a use for typmod. 

Regards,
	Jeff Davis


In response to

Responses

pgsql-hackers by date

Next:From: Decibel!Date: 2008-06-03 20:54:13
Subject: Re: Hint Bits and Write I/O
Previous:From: Decibel!Date: 2008-06-03 20:43:14
Subject: Re: BUG #4204: COPY to table with FK has memory leak

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group