Re: Proposal: CREATE CONVERSION

On Tue, Jul 09, 2002 at 10:07:11AM +0900, Tatsuo Ishii wrote:
> > > 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;
Hmm, but it require define "function_for_..." for each conversion. For example trigger function I needn't define for
eachtable, but I canuse only one PostgreSQL function for arbirary table.
 
   Karel

-- Karel Zak  <zakkr@zf.jcu.cz>http://home.zf.jcu.cz/~zakkr/C, PostgreSQL, PHP, WWW, http://docs.linux.cz,
http://mape.jcu.cz