Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: function not called if part of aggregate
- From: "Steinar H. Gunderson" <sgunderson(at)bigfoot(dot)com>
- To: pgsql-performance(at)postgresql(dot)org
- Subject: Re: function not called if part of aggregate
- Date: Sun, 11 Jun 2006 19:31:55 +0200
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/
- References:
- function not called if part of aggregate
- From: Craig A. James
- function not called if part of aggregate
- Prev by Date: function not called if part of aggregate
- Next by Date: Re: function not called if part of aggregate
- Previous by thread: function not called if part of aggregate
- Next by thread: Re: function not called if part of aggregate
- Indexes: