Re: using interval in a query with a column for the interval value?

On Thu, Aug 04, 2005 at 09:52:50 -0600,
"Walker, Jed S" <Jed_Walker(at)cable(dot)comcast(dot)com> wrote:
>
> Select name
> From table1
> Where last_date < now() - [[interval days]];
>
> The interval days part is what is stumping me I need to say "now() -
> interval '30 days'" but I need to use the interval column.

Use something like:
Where last_date < now() - Interval * '1 day'::interval