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?
pgsql-general by date
|Next:||From: Joolz||Date: 2004-11-30 10:31:18|
|Subject: Re: change natural column order|
|Previous:||From: deepthi||Date: 2004-11-30 10:29:15|
|Subject: Maximum limit on int in plpgsql|