Re: Proposal: CREATE CONVERSION

Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> I guess you mix up SQL99's "trasnlate" and "convert".

No, I believe Peter has read the spec correctly.  Further down they have
        <character translation> is a function for changing each character        of a given string according to some
many-to-oneor one-to-one        mapping between two not necessarily distinct character sets.
 

So this is intended as a one-character-at-a-time mapping, not a language
translation (which would be far beyond what anyone would expect of a
database anyway).

One thing that's really unclear to me is what's the difference between
a <character translation> and a <form-of-use conversion>, other than
that they didn't provide a syntax for defining new conversions.
        regards, tom lane