Postgres Pro
Downloads
Home   >   mailing lists

Re: function not called if part of aggregate - Mailing list pgsql-performance

From Steinar H. Gunderson
Subject Re: function not called if part of aggregate
Date
Msg-id 20060611173155.GA9244@uio.no
Whole thread Raw
In response to function not called if part of aggregate  ("Craig A. James" <cjames@modgraph-usa.com>)
List pgsql-performance
Tree view 
On Sun, Jun 11, 2006 at 10:18:20AM -0700, Craig A. James wrote:
> This works well, but it requires me to actually retrieve the function's
> value 800 times.

Is this actually a problem?

> So I thought I'd be clever:
>
>   select count(1) from (select foo_init(value) from foo_init_table order by
>   value_id) as foo;

Why not just count(foo_init(value))?

/* Steinar */
--
Homepage: http://www.sesse.net/

pgsql-performance by date:

Previous
From: "Craig A. James"
Date:
Subject: function not called if part of aggregate
Next
From: Tom Lane
Date:
Subject: Re: function not called if part of aggregate