Re: Antwort: Re: Subtracting fields in the Where Clause

Thanks Arne. Due to other conditions in the application I will have to loop
over the results, but I will use this View technique elsewhere. I appreciate
your help.

BR
Ruy
--- arne.siegel@xxxxxx wrote:

> 
> Hi,
> 
> you should consider defining a db view returning the computed value
> to_days(s.end_of_subscription_date) - to_days(SYSDATE()) as
> expiration_days.
> 
> You could then simplify your query to look like this:
> 
> SELECT user_id
> FROM details d, view_subscribers v
> WHERE v.app_id = d.app_id
> AND v.expiration_days = d.end_warning
> 
> which is easy to transform to torque queries.
> 
> Hope this helps
> Arne
> 
> 
> **********************************************************************
> http://www.pta.de
> Mit 1051 Erfahrungsberichten aus 35 Jahren erfolgreicher Projektarbeit!
> **********************************************************************
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@xxxxxxxxxxxxx
> For additional commands, e-mail: torque-user-help@xxxxxxxxxxxxx
> 
> 


=====
-------------------------------
I used to be an atheist, until I realized I was God.


                
__________________________________ 
Do you Yahoo!? 
Meet the all-new My Yahoo! - Try it today! 
http://my.yahoo.com