Re: [GENERAL] case-insensitive database

2003-09-14 Thread Dennis Gearon
Relaxin wrote: Hello Does anyone understand what is meant by a case-insensitive database. You could define your own encoding, and use that. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] case-insensitive database

2003-09-14 Thread Tom Lane
Stephan Szabo <[EMAIL PROTECTED]> writes: > Potentially on some systems it'd be possible to > generate a case insensitive collation as part of a locale > and then use such for LC_COLLATE on initdb which would make all > comparisons of text fields case insensitive. Another possibility is to create

Re: [GENERAL] case-insensitive database

2003-09-14 Thread Stephan Szabo
On Sat, 13 Sep 2003, Relaxin wrote: > No, I mean the data. > > select * from stocks where symbol = 'AADBX' > and > select * from stocks where symbol = 'aadbx' > > would bring up the same result set. Potentially on some systems it'd be possible to generate a case insensitive collation as part of

Re: [GENERAL] case-insensitive database

2003-09-14 Thread Relaxin
Thank you, that was the answer I was look for. "Stephan Szabo" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > On Sat, 13 Sep 2003, Relaxin wrote: > > > No, I mean the data. > > > > select * from stocks where symbol = 'AADBX' > > and > > select * from stocks where symbol = 'aadbx'

Re: [GENERAL] case-insensitive database

2003-09-14 Thread Relaxin
Hello Does anyone understand what is meant by a case-insensitive database. Are there some collations that can be changed or is there just no way to have a true case-insensitive Postgresql database? Thanks "Dennis Gearon" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Relaxin w

Re: [GENERAL] case-insensitive database

2003-09-14 Thread Stephan Szabo
On Sat, 13 Sep 2003, Relaxin wrote: > Is there a way to make Postgresql case-INSENSITIVE? Case insensitive in what regard? That textual comparisons are done case-insensitively in queries? That object names are determined case-insensitively? ---(end of broadcast)

Re: [GENERAL] case-insensitive database

2003-09-14 Thread Dennis Gearon
Relaxin wrote: No, I mean the data. select * from stocks where symbol = 'AADBX' and select * from stocks where symbol = 'aadbx' would bring up the same result set. Look in the manuals, there are SQL functions like: STRTOLOWER( ); STRTOUPPER() like those in 'C' Usage: --- SELECT * FROM

Re: [GENERAL] case-insensitive database

2003-09-14 Thread darren
select * from stocks where lower(symbol) = 'aadbx'; or select * from stocks where symbol ilike =aadbx'; or select * from stocks where symbol ~* 'aadbx'; HTH Darren On Sat, 13 Sep 2003, Relaxin wrote: > No, I mean the data. > > select * from stocks where symbol = 'AADBX' > and > select * from st

[GENERAL] case-insensitive database

2003-09-14 Thread Relaxin
Is there a way to make Postgresql case-INSENSITIVE? Thanks ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] case-insensitive database

2003-09-14 Thread Relaxin
No, I mean the data. select * from stocks where symbol = 'AADBX' and select * from stocks where symbol = 'aadbx' would bring up the same result set. "Christopher Browne" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Quoth "Relaxin" <[EMAIL PROTECTED]>: > > Is there a way to make

Re: [GENERAL] case-insensitive database

2003-09-14 Thread Christopher Browne
Quoth "Relaxin" <[EMAIL PROTECTED]>: > Is there a way to make Postgresql case-INSENSITIVE? It already is. portfolio=# select * from stocks limit 1; symbol | description | exchange +-+-- AADBX | AADBX | NYSE (1 row) portfolio=# sELeCT * FROM STOCKS LIMIT 1;