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 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 stocks > WHERE > STRTOLOWER( symbol ) = STRTOLOWER( 'AADBX' ); > > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
