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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

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