Thread: Re: [HACKERS] UTF8 or Unicode

Re: [HACKERS] UTF8 or Unicode

From
Bruce Momjian
Date:
lsunley@mb.sympatico.ca wrote:
> Further to my earlier e-mail, there would have to be two lines added to
> conversion_create.sql for each alternate function name
>
> Like:
>
> CREATE OR REPLACE FUNCTION ascii_to_whatever (INTEGER, INTEGER, CSTRING,
> CSTRING, INTEGER) RETURNS VOID AS '$libdir/ascmic', 'ascii_to_mic'
> LANGUAGE 'c' STRICT;
>
> CREATE CONVERSION pg_catalog.ascii_to_whatever FOR 'SQL_ASCII' TO
> 'MULE_INTERNAL' FROM ascii_to_whatever;

I would like to avoid bloating the system with aliases.  I think it is
OK to have it happen with specific names but doing it for all the
combinations is too much, and these duplicates are in the system tables,
not in the C code.  It just doesn't seem worth it to me.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073