Subject: Re: Denormalizing during select
From: Rod Taylor <rbt@rbt.ca>
To: Edmund Lian <no.spam@address.com>
Cc: pgsql-sql@postgresql.org
In-Reply-To: <eq8n5vcad8ut4hk3dba1g4q27c54gr6dbs@4ax.com>
References: <200302241433.49502.josh@agliodbs.com>
	<fhpl5v86vkhq26gifm9g4cb1kh2o2b6d6r@4ax.com>
	<eq8n5vcad8ut4hk3dba1g4q27c54gr6dbs@4ax.com>
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="=-Ua0c/hrkv3DXna4JFh1h"
Organization: 
Message-Id: <1046538423.26763.177.camel@jester>
Mime-Version: 1.0
Date: 01 Mar 2003 12:07:04 -0500

--=-Ua0c/hrkv3DXna4JFh1h
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

On Tue, 2003-02-25 at 13:48, Edmund Lian wrote:
> On Tue, 25 Feb 2003 03:44:02 GMT, Edmund Lian wrote:
>=20
> >I found this example in "Practical PostgreSQL"... will it do the job?
>=20
> Answering my own question: kind of. The problem with custom aggregates
> is that they need to be used with a "group by" clause, and this means
> that the select cannot return columns that are not aggregates of some
> kind. What I'm trying to return are rows that are a combination of
> columns and aggregates.

I've been trying to figure out how to give a running total (similar
issue I think).

key    	value
1	5
1	5
1	5
2	1
2	2
2	1


Query output:
key	value	sum to point
1	5	5
1	5	10
1	5	15
2	1	1
2	2	3
2	1	4


I think I should be able to do it with an aggregate -- but the best I've
been able to come up with is a Set Returning Function.

--=20
Rod Taylor <rbt@rbt.ca>

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

--=-Ua0c/hrkv3DXna4JFh1h
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (FreeBSD)

iD8DBQA+YOi36DETLow6vwwRAg07AJ9rJhfWoxsPnhKQDxji60sZCsFfTQCfcgDH
hklbDKBIm43clT8CKPxp98o=
=ADgy
-----END PGP SIGNATURE-----

--=-Ua0c/hrkv3DXna4JFh1h--