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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.