Re: Charset/collate support and function parameters

Поиск
Список
Период
Сортировка
От Dennis Bjorklund
Тема Re: Charset/collate support and function parameters
Дата
Msg-id Pine.LNX.4.44.0410310714360.2015-100000@zigo.dhs.org
обсуждение исходный текст
Ответ на Re: Charset/collate support and function parameters  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Ответы Re: Charset/collate support and function parameters  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Список 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 по дате отправления:

Предыдущее
От: Tatsuo Ishii
Дата:
Сообщение: Re: not null partial index?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: not null partial index?