Re: How do I do a dynamic - select now() + interval X days ?

On 08.08.2007, at 18:16, Jon Sime wrote:

> Abraham, Danny wrote:
>> Thanks
>
> For doing that based on an arbitrary value, just do the following:
>
> select now() + interval '1 day' * X;
>
> -Jon
>
test=# select (3||' day')::interval;
interval
----------
3 days
(1 row)

> --
> Senior Systems Developer
> Media Matters for America
> http://mediamatters.org/
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match

Kristo Kaiv
http://kaiv.wordpress.com (PostgreSQL blog)