Re: Using domains for case insensitivity

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Using domains for case insensitivity
Дата
Msg-id 200406171557.28691.peter_e@gmx.net
обсуждение исходный текст
Ответ на Using domains for case insensitivity  (Shachar Shemesh <psql@shemesh.biz>)
Ответы Re: Using domains for case insensitivity  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Shachar Shemesh wrote:
> According to the docs, domains are not meant for that purpose, but
> for changing constraints of a type. Is it possible to define a domain
> that will have the same defaults and constraints as the base type,
> but will have different comparison functions? Will that provide me
> with what I need?

Domains constrain the allowed values of a data type and nothing more.  
If you were able to override operators, then you would create a new 
data type, thus losing a fundamental property of domains.  So this is 
not the route you want to pursue.



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Shachar Shemesh
Дата:
Сообщение: Using domains for case insensitivity
Следующее
От: Shachar Shemesh
Дата:
Сообщение: in out send recv functions - immutable or stable?