Postgres Pro
Downloads
Home   >   mailing lists

can't find data type CIText or CI_Text - Mailing list pgsql-general

From Heine Ferreira
Subject can't find data type CIText or CI_Text
Date
Msg-id CAMuqQjch87WyaNiv14RFDvOhPQn_AijHbnoDtU68THFzCV_SAA@mail.gmail.com
Whole thread Raw
Responses Re: can't find data type CIText or CI_Text  (Thom Brown <thom@linux.com>)
List pgsql-general
Tree view
Hi

I was told by someone that in order to store text that isn't case sensitive in comparisons I must use CIText or CI_Text.
I can't find the data type? Also is this  char or varchar data type? Can you create an index on this data type?

Thanks

H.F.

pgsql-general by date:

Previous
From: Manoj Govindassamy
Date:
Subject: PG synchronous replication and unresponsive slave
Next
From: Thom Brown
Date:
Subject: Re: can't find data type CIText or CI_Text