Re: Denormalizing during select - Mailing list pgsql-sql

From Edmund Lian
Subject Re: Denormalizing during select
Date
Msg-id eq8n5vcad8ut4hk3dba1g4q27c54gr6dbs@4ax.com
Whole thread Raw
In response to Re: Denormalizing during select  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Denormalizing during select
Re: Denormalizing during select
Re: Denormalizing during select
List pgsql-sql
On Tue, 25 Feb 2003 03:44:02 GMT, Edmund Lian wrote:

>I found this example in "Practical PostgreSQL"... will it do the job?

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.

...Edmund.


pgsql-sql by date:

Previous
From: Edmund Lian
Date:
Subject: Re: Denormalizing during select
Next
From: Jeff Eckermann
Date:
Subject: Re: Executing SQL commands via triggers without the use of procedures