Re: date interpolation

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: Rob Wood <rhwood(at)dobber(dot)ca>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: date interpolation
Date: 2003-05-26 02:37:45
Message-ID: 1053916664.279.162.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> So far the closest solution I have come up with involves creating a dummy
> table that contains a long list of dates that I can JOIN against in order
> to fill in the interpolated values. It doesn't work very well, and gets
> slow with large tables.

Looks to me like the perfect candidate for a Set Returning Function.

--
Rod Taylor <rbt(at)rbt(dot)ca>

PGP Key: http://www.rbt.ca/rbtpub.asc

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Mintoo Lall 2003-05-26 02:48:29 Using UPPER and TRIM (INDEX usage)
Previous Message Tom Lane 2003-05-25 22:59:04 Re: Quick question regarding indexes and NULLs in 7.3.3 -> 7.4