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

From Tatsuo Ishii
Subject Re: Proposal: CREATE CONVERSION
Date
Msg-id 20020706.003330.59668263.t-ishii@sra.co.jp
Whole thread Raw
In response to Re: Proposal: CREATE CONVERSION  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Proposal: CREATE CONVERSION  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Proposal: CREATE CONVERSION  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
> > CREATE CONVERSION <conversion name>
> >        SOURCE <source encoding name>
> >        DESTINATION <destination encoding name>
> >        FROM <conversion function name>
> 
> Doesn't a conversion currently require several support functions?
> How much overhead will you be adding to funnel them all through
> one function?

No, only one function is sufficient. What else do you think of?

> Basically I'd like to see a spec for the API of the conversion
> function...

That would be very simple (the previous example I gave was unnecessary
complex). The function signature would look like:

conversion_funcion(TEXT) RETURNS TEXT

It receives source text and converts it then returns it. That's all.

> 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.
--
Tatsuo Ishii




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: DROP COLUMN Progress
Next
From: Tom Lane
Date:
Subject: Re: Proposal: CREATE CONVERSION