Re: citext question

On Oct 13, 2012, at 6:34 PM, David Johnston <polobo@yahoo.com> wrote:

>>
>> Hi
>>
>> I have played around a bit with the citext
>> extention. It looks like it is a lot like the
>> text data type - allmost like a memo
>> field. Is there any way to restrict the
>> length of citext fields, like char and
>> varchar fields?
>>
>> Thanks
>>
>> H.F.
>>
>
> Try "citext(25)"...if it works then "yes" otherwise "no"...

No, citext(length) not supported.

However, you can define check constraint, if that fulfill your requirement as given below:
create table test2(col citext check(length(col) < 3));
Or
you can create a domain which you can use in CREATE TABLE command as given below:
CREATE domain citext_char as CITEXT CHECK(length(value) <= 3);

Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
Blog: http://vibhork.blogspot.com