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 month' rather than attempting to do it via text. ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend