(BI have an application which makes extensive use
(Bof hash references when fetching and manipulating
(Bquery results. As the underlying database is PostgreSQL,
(Bthe returned hash keys are lower case (unless otherwise
(Bspecified).
(B
(Be.g. with this:
(B
(B my $sth = $dbh->prepare('SELECT foo FROM bar LIMIT 1');
(B $sth->execute();
(B my $res = $sth->fetchrow_hashref();
(B
(B$res->{foo} will contain the value selected.
(B
(BOracle however defaults to upper case, so with the
(Babove code, $res->{FOO} will contain the result.
(B
(BMy question is therefore:
(Bis there any way of forcing DBI (or Oracle) to return lower case names by
(Bdefault?
(B
(BHaving looked into it and not found any positive answers,
(Bmy suspicion is that this is not possible, but would like confirmation
(Bbefore I move on to Plan B.
(B
(BI am aware that I could
(Ba) create the objects in Oracle with quoted lowercase names; or
(Bb) use e.g. 'SELECT foo AS "foo" FROM bar LIMIT 1'
(B
(Bbut would like to avoid doing this.
(B
(BThanks for any info
(B
(B
(BIan Barwick
([EMAIL PROTECTED]
