Postgres Pro
Downloads
Home   >   mailing lists

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

From Jim C. Nasby
Subject Re: function not called if part of aggregate
Date
Msg-id 20060611174837.GF34196@pervasive.com
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 doesn't seem right to me -- how can the optimizer possibly know that a
> function doesn't have a side effect, as in my case?  Functions could do all
> sorts of things, such as logging activity, filling in other tables, etc,
> etc.
>
> Am I missing something here?

Read about function stability in the docs.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: function not called if part of aggregate
Next
From: Greg Stark
Date:
Subject: Re: function not called if part of aggregate