| From: | "David E(dot) Wheeler" <david(at)kineticode(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-hackers Hackers <pgsql-hackers(at)postgresql(dot)org>, Ryan Bradetich <rbradetich(at)gmail(dot)com> |
| Subject: | Re: [Review] Tests citext casts by David Wheeler. |
| Date: | 2008-09-12 18:35:42 |
| Message-ID: | 3C2A6DD6-169D-4A65-A9C2-E12A669D13A9@kineticode.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Sep 12, 2008, at 11:31, Tom Lane wrote:
> "David E. Wheeler" <david(at)kineticode(dot)com> writes:
>> Oh, and text_name seems to give me this error:
>
>> ERROR: compressed data is corrupt
>
>> That's when I have this cast:
>
>> CREATE OR REPLACE FUNCTION citext(name)
>> RETURNS citext
>> AS 'text_name'
>> LANGUAGE internal IMMUTABLE STRICT;
>
> I think you've got the direction backwards.
Oh. Duh.
> BTW, I removed the "Limitations" entry about I/O casting not working
> with citext; we fixed that, no?
Yes, we did. Thanks for the catch.
I've got another patch I'm working on adding support for "char" (and
tests for char). Just to fill out a gap I saw in the casting coverage.
I'm trying to get it done now. With that, AFAIK, citext will work just
like text.
Best,
David
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David E. Wheeler | 2008-09-12 18:48:21 | Re: [Review] Tests citext casts by David Wheeler. |
| Previous Message | Tom Lane | 2008-09-12 18:34:27 | Re: [Review] Tests citext casts by David Wheeler. |