in reply to Re: Backslash and Underscore problem with DBI and PostgreSQL.
in thread Backslash and Underscore problem with DBI and PostgreSQL.
The code I show above is from a couple years ago when I first began using SQL and everything I've found in the postgresql mailing lists and docs indicated that if I wanted to do a case insensitive search, I needed to use the regex operators of ~* or ~~* and this is why you see the instructions above.
Using an '=' isn't case insensitive but I realize that I could and probably should be using lower() as in SELECT uid FROM accounts WHERE lower(username) = lower(?).
Is this the correct and fastest way to handle this? I realize my questions in this thread are really more geared toward PostgreSQL than perl, but it involves the perl DBI to some degree. And I know my question is a bit rudimentary to DBAs - but I'm not one and your responses are always greatly appreciated. :)
Using an '=' isn't case insensitive but I realize that I could and probably should be using lower() as in SELECT uid FROM accounts WHERE lower(username) = lower(?).
Is this the correct and fastest way to handle this? I realize my questions in this thread are really more geared toward PostgreSQL than perl, but it involves the perl DBI to some degree. And I know my question is a bit rudimentary to DBAs - but I'm not one and your responses are always greatly appreciated. :)
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^3: Backslash and Underscore problem with DBI and PostgreSQL.
by Zaxo (Archbishop) on Jun 21, 2004 at 04:50 UTC | |
by Seumas (Curate) on Jun 21, 2004 at 05:04 UTC | |
Re^3: Backslash and Underscore problem with DBI and PostgreSQL.
by mpeppler (Vicar) on Jun 21, 2004 at 07:15 UTC | |
by ctilmes (Vicar) on Jun 21, 2004 at 11:44 UTC | |
by Seumas (Curate) on Jun 21, 2004 at 23:58 UTC |
In Section
Seekers of Perl Wisdom