On Oct 13, 2012, at 6:34 PM, David Johnston <pol...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
