Re^2: Backslash and Underscore problem with DBI and PostgreSQL.

in reply to Re: Backslash and Underscore problem with DBI and PostgreSQL.
in thread Backslash and Underscore problem with DBI and PostgreSQL.

No, I definitely wouldn't say DBI:: sucks. It's a great package and makes life tolerable.

I'm just frustrated that it isn't more simple to find some obvious answers sometimes. It isn't like I didn't search the postgresql and DBI documentation and postgresql mailing list archives for an answer (and ask for help in #postgresql) - yet the only answer I could find was the regex solution!

In fact, now that I know better, it's clear that the answers to people in the mailing lists that I read themselves were also wrong. Self-education is often frustrating, but places like PM make it much easier... assuming one can overcome the fear of looking stupid for asking stupid or rudimentary questions. :)

Of course, now if anyone else has such a stupid question, they'll get the right answer here with the keywords "sql dbi insensitive" ;)

Comment on Re^2: Backslash and Underscore problem with DBI and PostgreSQL.

Replies are listed 'Best First'.
Re^3: Backslash and Underscore problem with DBI and PostgreSQL. by hmerrill (Friar) on Jun 21, 2004 at 12:59 UTC
There are NO stupid questions! We've all been there ;-) It takes time to become familiar with the different pieces that make up a Perl Database application. Be aware that using '~' and '~~' pattern matching in your queries is most probably a PostgreSQL-specific thingy. Just my personal opinion here, but I try to stay away from database specific functions because if at some point in the future you change your database from Postgresql to Oracle (or whatever), you'll have to redo that code entirely. I try to stick with "standard" SQL and try to stay away from database specific functions. In this specific instance, the "lower" function will provide a database-independent way of doing a case-insensitive query. IMHO "lower" is a much better solution since it is database-independent.	[reply]

Replies are listed 'Best First'.

Re^3: Backslash and Underscore problem with DBI and PostgreSQL.
by hmerrill (Friar) on Jun 21, 2004 at 12:59 UTC

Be aware that using '~*' and '~~*' pattern matching in your queries is most probably a PostgreSQL-specific thingy. Just my personal opinion here, but I try to stay away from database specific functions because if at some point in the future you change your database from Postgresql to Oracle (or whatever), you'll have to redo that code entirely.

I try to stick with "standard" SQL and try to stay away from database specific functions. In this specific instance, the "lower" function will provide a database-independent way of doing a case-insensitive query. IMHO "lower" is a much better solution since it is database-independent.

[reply]

In Section Seekers of Perl Wisdom