Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL executing my function too many times during query - Mailing list pgsql-general

From Tom Lane
Subject Re: PostgreSQL executing my function too many times during query
Date
Msg-id 4524.1210983949@sss.pgh.pa.us
Whole thread Raw
In response to Re: PostgreSQL executing my function too many times during query  ("D. Dante Lorenso" <dante@lorenso.com>)
List pgsql-general
Tree view 
"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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Pg_dump version mismatch
Next
From: Chuck Bai
Date:
Subject: Function to return both integer and SETOF refcursor