X-Original-To: pgsql-sql@postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id AA8039258D9 for ; Sun, 25 May 2003 22:38:01 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 20561-02 for ; Sun, 25 May 2003 22:37:56 -0400 (EDT) Received: from tomts11-srv.bellnexxia.net (tomts11.bellnexxia.net [209.226.175.55]) by developer.postgresql.org (Postfix) with ESMTP id A89479258D6 for ; Sun, 25 May 2003 22:37:55 -0400 (EDT) Received: from [192.168.1.200] ([64.231.215.231]) by tomts11-srv.bellnexxia.net (InterMail vM.5.01.05.32 201-253-122-126-132-20030307) with ESMTP id <20030526023753.QHIT5754.tomts11-srv.bellnexxia.net@[192.168.1.200]>; Sun, 25 May 2003 22:37:53 -0400 Subject: Re: date interpolation From: Rod Taylor To: Rob Wood Cc: pgsql-sql@postgresql.org In-Reply-To: References: Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-g04LjEpAaRBTNfkA9ICT" Organization: Message-Id: <1053916664.279.162.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.4 Date: 25 May 2003 22:37:45 -0400 X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/492 X-Sequence-Number: 13657 --=-g04LjEpAaRBTNfkA9ICT Content-Type: text/plain Content-Transfer-Encoding: quoted-printable > 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= =20 > to fill in the interpolated values. It doesn't work very well, and gets= =20 > slow with large tables. Looks to me like the perfect candidate for a Set Returning Function. --=20 Rod Taylor PGP Key: http://www.rbt.ca/rbtpub.asc --=-g04LjEpAaRBTNfkA9ICT Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (FreeBSD) iD8DBQA+0X346DETLow6vwwRAuDOAJ42Yq4hq2A5+Z6ZSkTv73/GCS5bLgCeIcMT TNJJrj0RSIaBellWIZgLcXo= =JvP4 -----END PGP SIGNATURE----- --=-g04LjEpAaRBTNfkA9ICT--