Re: function not called if part of aggregate

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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/


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux