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)
