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

From Tatsuo Ishii
Subject Re: Proposal: CREATE CONVERSION
Date
Msg-id 20020706.095332.115922236.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>)
List pgsql-hackers
> I see two different functions linked to from each pg_wchar_table
> entry... although perhaps those are associated with encodings
> not with conversions.

Yes. those are not directly associated with conversions.

> IIRC the existing conversion functions deal in C string pointers and
> lengths.  I'm a little worried about the extra overhead implicit
> in converting to a TEXT object and back again; that probably means at
> least two more palloc and memcpy operations.  I think you'd be better
> off sticking to a C-level API, because I really don't believe that
> anyone is going to code conversion functions in (say) plpgsql.

I am worried about that too. But if we stick a C-level API, how can we
define the argument data type suitable for C string? I don't see such
data types. Maybe you are suggesting that we should not use CREATE
FUNCTION?
--
Tatsuo Ishii




pgsql-hackers by date:

Previous
From: Manfred Koizar
Date:
Subject: Page type and version
Next
From: Bruce Momjian
Date:
Subject: Re: Issues Outstanding for Point In Time Recovery (PITR)