Working with intervals in where clauses

Hi, not very experienced with postgre, so trying this place to get some help...

My issue is to create some where clauses with intervals, however my try to "7776000 - (timestamp '2009-10-18 10:50:04.604' - activated_at))) > activity_used" where activity_used is an integer and activated_at a timestamp - how to correctly do these things, any example?

Thanks

Note it's either Postgres or PostgreSQL
"postgre" is usually frowned upon


So what does 7776000 stand for? seconds, minutes, hours, days, a date?
What unit is the integer in activity_used? seconds, minutes, hours, days?

And why don't you use the interval data type for those integer values?

Could you explain what your statement is supposed to do?

And you might want to check out the manual about date functions:
http://www.postgresql.org/docs/current/static/functions-datetime.html