Re: [CDBI] Make CDBI go fast
"Jay Strauss" <[email protected]>
| Newsgroups | gmane.comp.lang.perl.modules.class-dbi |
|---|---|
| Message-ID | <[email protected]> |
<Not a speed wish>
I always thought it would be nice to have a syntax for using database
specific functions within the generic CDBI syntax, instead of having
to litter my code with set_sql statements.
For example (oracle) :
set_sql(expiration_dates=>qq{
select distinct(to_char(expirationtms,'yyyy/mm/dd')) expirationtms
from security
where underlyingsecurityid = ?
and expirationtms >= sysdate});
I'd love to be able to use "to_char", "to_date", "sysdate" within CDBI
my 2 cents
Jay