STABLE has no effect on PL/pgsql functions - Mailing list pgsql-novice

From psql-novice@netzach.co.il
Subject STABLE has no effect on PL/pgsql functions
Date
Msg-id Pine.LNX.4.58.0706011149200.22093@perpetual.homelinux.org
Whole thread Raw
Responses Re: STABLE has no effect on PL/pgsql functions  (Oliver Elphick <olly@lfix.co.uk>)
List 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

pgsql-novice by date:

Previous
From: "Burak Seydioglu"
Date:
Subject: Re: Processing Tables containing tree-like data
Next
From: psql-novice@netzach.co.il
Date:
Subject: Re: STABLE has no effect on PL/pgsql functions