Re: Case insensitivity, and option?

> -----Original Message-----
> From: Dwayne Miller [mailto:dmiller@espgroup.net] 
> Sent: 12 March 2003 18:35
> To: PostgreSQL Development
> Subject: Re: [HACKERS] Case insensitivity, and option?
> 
> 
> I know that the MSSQL code works because the default 
> collation sequence 
> for character fields is case-insensitive.  You can change it for each 
> field independantly to be case sensitive, local specific, 
> etc.  I'm not 
> sure if PG supports a collation sequence attribute on column 
> definitions/indexes.

Iirc, you can set the default collation at install time - I believe the
default is case sensitive.

Regards, Dave.