Re: Proposal: CREATE CONVERSION - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: Proposal: CREATE CONVERSION
Date
Msg-id 20020709.100711.35681203.t-ishii@sra.co.jp
Whole thread Raw
In response to Re: Proposal: CREATE CONVERSION  (Karel Zak <zakkr@zf.jcu.cz>)
Responses Re: Proposal: CREATE CONVERSION  (Karel Zak <zakkr@zf.jcu.cz>)
List pgsql-hackers
> > Use a simple wrap function.
> 
>  How knows this function to/from encoding? 

For example you want to define a function for LATIN1 to UNICODE conversion
function would look like:

function_for_LATIN1_to_UTF-8(from_string opaque, to_string opaque, length
integer)
{::generic_function_using_iconv(from_str, to_str, "ISO-8859-1", "UTF-8",length);
}

CREATE FUNCTION function_for_LATIN1_to_UTF-8(opaque, opaque, integer)
RETURNS integer;
CREAE CONVERSION myconversion FOR 'LATIN1' TO 'UNICODE' FROM
function_for_LATIN1_to_UTF-8;





pgsql-hackers by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: Proposal: CREATE CONVERSION
Next
From: Rod Taylor
Date:
Subject: More fun with BETWEEN