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

Поиск
Список
Период
Сортировка
От David E. Wheeler
Тема Re: [Review] Tests citext casts by David Wheeler.
Дата
Msg-id 1076562A-DE44-4A6C-8ABC-AF4B2D7922C9@kineticode.com
обсуждение исходный текст
Ответ на Re: [Review] Tests citext casts by David Wheeler.  ("David E. Wheeler" <david@kineticode.com>)
Ответы Re: [Review] Tests citext casts by David Wheeler.
Список pgsql-hackers
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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "David E. Wheeler"
Дата:
Сообщение: Re: [Review] Tests citext casts by David Wheeler.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [Review] Tests citext casts by David Wheeler.