| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Peter Darley" <pdarley(at)kinesis-cem(dot)com> |
| Cc: | "Russell Black" <russell(dot)black(at)iarchives(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Case Insensitive Data Type |
| Date: | 2002-05-24 22:37:24 |
| Message-ID: | 21811.1022279844@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Peter Darley" <pdarley(at)kinesis-cem(dot)com> writes:
> I don't want to imply something about things I don't know anything about,
> but I'm interested in why nobody has suggested creating a new data type
> using CREATE TYPE, setting up it's various functions and creating new
> operators for it. It looks (reading the docs) like it would do what Russel
> wants without too much work. Is there some reason that folks avoid this
> approach?
That's what I was referring to at the end of the message you quoted.
The question is what you define as "too much work" ;-).
Given a C implementation of the required normalization function (I'm
assuming plain lower() won't really cut it), you'd need probably O(100)
lines of additional C code and a few dozen catalog entries to make it
happen. A couple hours work for someone who'd done it before, rather
longer for someone who hadn't ...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Russell Black | 2002-05-24 22:53:43 | Re: Case Insensitive Data Type |
| Previous Message | Tom Lane | 2002-05-24 22:24:58 | Re: How to add big amounts of data into database? |