Doug Budny wrote:
>
> Is it possible to turn off "Case Sensitivity" in PostgreSQL on Linux?
>
> I have an Access database that I really want to get off of any MS platform,
> but I can't do it if pgsql cannot become insensitive to case. Does anybody
> have any suggestions?
Do you mean you want a text type feild to be case insensitive on
the equals comparison? So the folling two where clauses would be
the same
WHERE name = "FooBar"
WHERE name = "fOObAR"
If you really need this you can define a new type along with a
case insensitive "=" operator. or just redefine the = for an
existing character type.
--
Chris Albertson
[EMAIL PROTECTED] Voice: 626-351-0089 X127
Logicon, Pasadena California Fax: 626-351-0699
