Re: function not called if part of aggregate

From: "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: function not called if part of aggregate
Date: 2006-06-11 17:31:55
Message-ID: 20060611173155.GA9244@uio.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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/

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2006-06-11 17:39:30 Re: function not called if part of aggregate
Previous Message Craig A. James 2006-06-11 17:18:20 function not called if part of aggregate