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

From Tatsuo Ishii
Subject Re: Proposal: CREATE CONVERSION
Date
Msg-id 20020707.213057.71105070.t-ishii@sra.co.jp
Whole thread Raw
In response to Re: Proposal: CREATE CONVERSION  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Proposal: CREATE CONVERSION
List pgsql-hackers
> Tatsuo Ishii writes:
> 
> > > Also, is there anything in SQL99 that we ought to try to be
> > > compatible with?
> >
> > As far as I know there's no such an equivalent in SQL99.
> 
> Sure:
> 
>          11.34  <translation definition>

I guess you mix up SQL99's "trasnlate" and "convert".

As far as I know, SQL99's "translation" is exactly a translation. e.g.
       rr) translation: A method of translating characters in one character           repertoire into characters of the
sameor a different character           repertoire.
 

For example, certain "translation" might take an input of Engish text,
and makes an output of Japanese one (I don't know if we could
implement such a translation though :-).

On the other hand "convert" just changes the "form-of-use" (SQL's
term, actually equivalent to "encoding"), keeping the character
repertoire.
--
Tatsuo Ishii




pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: libpq++ build problems
Next
From: Bruce Momjian
Date:
Subject: Re: libpq++ build problems