Re: Denormalizing during select

From: Edmund Lian <no(dot)spam(at)address(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Denormalizing during select
Date: 2003-02-25 18:48:19
Message-ID: eq8n5vcad8ut4hk3dba1g4q27c54gr6dbs@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Roberto Mello 2003-02-25 19:20:43 Return type of triger functions from OPAQUE to TRIGGER in 7.3
Previous Message Josh Berkus 2003-02-25 18:24:19 Re: Denormalizing during select