Hello!
Here's my test database:
# table
CREATE TABLE public.t
(
id integer NOT NULL,
a integer NOT NULL,
CONSTRAINT pk_t PRIMARY KEY (id)
)
CREATE INDEX idx_t_a
ON public.t
USING btree
(a);
# function
CREATE OR REPLACE FUNCTION public.f()
RETURNS integer AS
$BODY$BEGIN
RET
Hi Tom,
Thank you very much for your explanation.
On 13.08.2007, at 23:01, Tom Lane wrote:
Philipp Specht <[EMAIL PROTECTED]> writes:
The biggest question here is: Why is the runtime of the query with
the stable function not near the runtime of the immutable function?
Stable fun
Hello!
Here's my test database:
# table
CREATE TABLE public.t
(
id integer NOT NULL,
a integer NOT NULL,
CONSTRAINT pk_t PRIMARY KEY (id)
)
CREATE INDEX idx_t_a
ON public.t
USING btree
(a);
# function
CREATE OR REPLACE FUNCTION public.f()
RETURNS integer AS
$BODY$BEGIN
RET
