Re: Charset/collate support and function parameters - Mailing list pgsql-hackers

From Dennis Bjorklund
Subject Re: Charset/collate support and function parameters
Date
Msg-id Pine.LNX.4.44.0410310714360.2015-100000@zigo.dhs.org
Whole thread Raw
In response to Re: Charset/collate support and function parameters  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Responses Re: Charset/collate support and function parameters
List pgsql-hackers
On Sun, 31 Oct 2004, Tatsuo Ishii wrote:

> > and now we could add functions that work with this charset
> > 
> >   CREATE FUNCTION bar (x VARCHAR(255) CHARACTER SET foo) ....
> > 
> > What we are saying is that we don't want to be able to do this?
> 
> Not sure we want to add above. Is it something defined in the
> standard?

The syntax in sql2003 do allow it. The exact semantics is difficult to 
get a clear picture of from the spec (as always).

I thought this question was the whole argument. We can't have something 
like the above with the pg overloading since then the resolving process 
will be too hard according to Tom.

> 2) make shared tables such as pg_database and pg_shadow can handle
>    multiple charsets. this is necessary because database names and
>    user names could be repsented in different charsets

Shouldn't we just define the charset for user names and database names?  
Either one fixed or one that's set during initdb.  You don't mean that we
want different user numes to be defined using different charsets?

The rest of the points looks good to me. The main problem is still what to
do with the function definitions as above. Is it something we want or not?

Is the charset something that makes two text types different or not?

-- 
/Dennis Björklund



pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: not null partial index?
Next
From: Tom Lane
Date:
Subject: Re: not null partial index?