Postgres Pro
Downloads
Home   >   mailing lists

Re: date interpolation - Mailing list pgsql-sql

From Rod Taylor
Subject Re: date interpolation
Date
Msg-id 1053916664.279.162.camel@jester
Whole thread Raw
In response to date interpolation  (Rob Wood <rhwood@dobber.ca>)
List pgsql-sql
Tree view 
> 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@rbt.ca>

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

pgsql-sql by date:

Previous
From: Rob Wood
Date:
Subject: date interpolation
Next
From: Mintoo Lall
Date:
Subject: Using UPPER and TRIM (INDEX usage)