Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Possible to set postgres in case insensitive mode ?
- From: Bill Moran <wmoran(at)potentialtech(dot)com>
- To: Moe <mohamed5432154321(at)gmail(dot)com>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: Possible to set postgres in case insensitive mode ?
- Date: Fri, 29 Jan 2010 16:57:18 -0500
- Message-id: <20100129165718.344325e9.wmoran@potentialtech.com> <text/plain>
In response to Moe <mohamed5432154321(at)gmail(dot)com>: > Is it possible to set postgres in case insensitive mode ? > > If so, how? Keywords are always case-insensitive. Identifiers are case-insensitive unless you surround them with "". Strings are case-sensitive unless you use ILIKE or similar methods of comparison. All of these conform to what I'm used to in other database systems. If the above doesn't answer your question, perhaps provide a little more detail about what you're trying to do and where you're having problems. -- Bill Moran http://www.potentialtech.com http://people.collaborativefusion.com/~wmoran/
- References:
- Prev by Date: Re: Possible to set postgres in case insensitive mode ?
- Next by Date: storing windows path strings
- Previous by thread: Re: Possible to set postgres in case insensitive mode ?
- Next by thread: Re: Possible to set postgres in case insensitive mode ?
- Indexes: