Re: [Review] Tests citext casts by David Wheeler.

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: Raw Message | Whole Thread | 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

In response to

Responses

Browse pgsql-hackers by date

  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.