Temporal query question - Mailing list pgsql-general

From Stefano Bonnin
Subject Temporal query question
Date
Msg-id 006001c4d6c7$955fdc60$0501a8c0@comai04
Whole thread Raw
Responses Re: Temporal query question
Re: Temporal query question
List pgsql-general
Hi all,
 
I have a "simple" question about the following temporal query with "interval" operator:
 
can I define a query of this type?
 
select myfield,numeric_field from mytable where temporal_attribute < temporal_attribute - interval numeric_field || ' days'
 
obviously this syntax is wrong.
In other words, is there a way to define a query with a interval operator with variable argument?
Thanks
Stefano

pgsql-general by date:

Previous
From: Tino Wildenhain
Date:
Subject: Re: change natural column order
Next
From: deepthi@granwill.com
Date:
Subject: Maximum limit on int in plpgsql