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

From Tatsuo Ishii
Subject Re: Proposal: CREATE CONVERSION
Date
Msg-id 20020709.154640.98878620.t-ishii@sra.co.jp
Whole thread Raw
In response to Proposal: CREATE CONVERSION  (Tatsuo Ishii <t-ishii@sra.co.jp>)
List pgsql-hackers
SQL99 allows on the fly encoding conversion:

CONVERT('aaa' USING myconv 'bbb')

So there could be more than 1 conversion for a paticlular encodings
pair. This lead to an ambiguity for "default" conversion used for the
frontend/backend automatic encoding conversion. Can we add a flag
indicating that this is the "default" conversion? The new proposed
syntax would be:

CREATE CONVERSION <conversion name>      FOR <source encoding name>      TO <destination encoding name>      FROM
<conversionfunction name>      [DEFAULT]
 

Comments?
--
Tatsuo Ishii




pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: Proposal: CREATE CONVERSION
Next
From: Tatsuo Ishii
Date:
Subject: Re: Proposal: CREATE CONVERSION