Re: [GENERAL] citext question

2012-10-13 Thread Craig Ringer
On 10/14/2012 05:48 AM, Heine Ferreira 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? First, don't use "char(n

Re: [GENERAL] citext question

2012-10-13 Thread Vibhor Kumar
On Oct 13, 2012, at 6:34 PM, David Johnston 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

Re: [GENERAL] citext question

2012-10-13 Thread David Johnston
On Oct 13, 2012, at 17:48, Heine Ferreira 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? > > T