View Single Post

   
  #5 (permalink)  
Old 05-18-2008, 10:02 PM
Tom Lane
 
Posts: n/a
Default Re: PostgreSQL executing my function too many times during query

"D. Dante Lorenso" <dante@lorenso.com> writes:
> Tom Lane wrote:
>> I can't reproduce any such problem in 8.2 branch tip, and a desultory
>> scan of the CVS history back to 8.2.4 doesn't turn up any obviously
>> related patches. Please provide a self-contained test case for what
>> you're seeing.


> I think this is a problem with the BYTEA type.


So far as I can tell, it's a problem with having declared the function
STABLE. You want IMMUTABLE if you're hoping to have this usage folded
to a constant.

regards, tom lane

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply With Quote