STABLE has no effect on PL/pgsql functions

From: psql-novice(at)netzach(dot)co(dot)il
To: pgsql-novice(at)postgresql(dot)org
Subject: STABLE has no effect on PL/pgsql functions
Date: 2007-06-01 08:54:13
Message-ID: Pine.LNX.4.58.0706011149200.22093@perpetual.homelinux.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


I noted in my PG 7.4 on Debian Sarge the following behavior:

EXPLAIN ANALYZE SELECT *,reallyHeavyFunctionDefinedAsImmutable() FROM
my_table;
time taken: forever

EXPLAIN ANALYZE SELECT *,
(SELECT reallyHeavyFunctionDefinedAsImmutable())
FROM my_table;
time taken: not very long

First question: Is there a good reason for this difference ?

Second question: If not, when will it be (or was it) fixed ?

Netzach

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Oliver Elphick 2007-06-01 09:42:08 Re: STABLE has no effect on PL/pgsql functions
Previous Message Burak Seydioglu 2007-05-31 23:02:22 Re: Processing Tables containing tree-like data