On Sep 12, 2008, at 11:14, David E. Wheeler wrote:
> Pity. Looks like there were only a few I wasn't using, text_char,
> char_text, text_name, and texttoxml.
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;
This version does not give me an error:
CREATE OR REPLACE FUNCTION citext(name)
RETURNS citext
AS 'SELECT text( $1 )::citext'
LANGUAGE SQL IMMUTABLE STRICT;
Maybe I did something wrong?
Thanks,
David