Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Received-SPF: pass (hermes.apache.org: local policy)
To: "Apache Torque Users List" <torque-user@db.apache.org>
From: arne.siegel@pta.de
Subject: Antwort: Re: Subtracting fields in the Where Clause
MIME-Version: 1.0
Date: Tue, 16 Nov 2004 11:24:58 +0100
Message-ID: <OF18FEE0D0.22B6D2F5-ONC1256F4E.003937A5-C1256F4E.003937AF@pta.de>
Content-type: text/plain; charset=us-ascii


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@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org