Re: [HACKERS] Using domains for case insensitivity

2004-06-18 Thread Tom Lane
Peter Eisentraut [EMAIL PROTECTED] writes: 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

[HACKERS] Using domains for case insensitivity

2004-06-17 Thread Shachar Shemesh
Hi all, A while back I asked about creating a case insensitive postgresql. Tom, at the time, suggested I create a case insensitive type instead. I am now trying to go that route, and am wondering whether domains will provide a shortcut for me. As far as I understand the task at hand, I am

Re: [HACKERS] Using domains for case insensitivity

2004-06-17 Thread Peter Eisentraut
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