Hi Stephan
Thank you
> d1 + dur * interval '1 month'
works ;-)
Regards
Conni
---(end of broadcast)---
TIP 8: explain analyze is your friend
On Sat, 10 Jan 2004, Cornelia Boenigk wrote:
> I have a table with two fields, d1 timestamp and dur smallint.
> d1 is the starting date and dur is the duration. From this two fields
> I want to generate future dates for the whole table.
I'd suggest using something like:
d1 + dur * interval '1 m
Hi alltogether
I have a table with two fields, d1 timestamp and dur smallint.
d1 is the starting date and dur is the duration. From this two fields
I want to generate future dates for the whole table.
There is no problem with queries where a number for the duration is
given.
test=# select d1,dur,
