Re: citext question - Mailing list pgsql-general

From David Johnston
Subject Re: citext question
Date
Msg-id 4B444FA2-AF2B-4D8E-9C07-E3E279145F80@yahoo.com
Whole thread Raw
In response to citext question  (Heine Ferreira <heine.ferreira@gmail.com>)
Responses Re: citext question  (Vibhor Kumar <vibhor.kumar@enterprisedb.com>)
List pgsql-general
On Oct 13, 2012, at 17:48, Heine Ferreira <heine.ferreira@gmail.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"...

David J.


pgsql-general by date:

Previous
From: Leif Biberg Kristensen
Date:
Subject: Re: database corruption questions
Next
From: John R Pierce
Date:
Subject: Re: database corruption questions