From: Octavio Alvarez <alvarezp@alvarezp.ods.org>
To: Tomasz Myrta <jasiek@klaster.net>
Cc: Lista dyskusyjna pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: [PERFORM] Seq scan on zero-parameters function
Date: Fri, 6 Feb 2004 09:24:52 -0800 (PST)
Message-ID: <3080.192.168.0.64.1076088292.squirrel@alvarezp.ods.org> (raw)
In-Reply-To: <4023567E.1020406@klaster.net>
References: <4207.192.168.0.64.1076051944.squirrel@alvarezp.ods.org>
<40234207.6040207@klaster.net>
<4795.192.168.0.64.1076056992.squirrel@alvarezp.ods.org>
<4023567E.1020406@klaster.net>
Tomasz Myrta said:
> Dnia 2004-02-06 09:43, U¿ytkownik Octavio Alvarez napisa³:
>> Thanks for the hint.
>>
>> In fact, my current_period_id() is based on time, but it should be
>> constant along the query execution. I mean, I don't want some records
>> filtered with some values and other with other values... I'll have an
>> uncongruent recordset.
>
> Well - you didn't read the chapter I noticed you, did you?
Huummm.. No... :-$
But now I did. Although the chapter makes it look as "how will the
optimizer think the function behaves", not "how the function actually
behaves".
But thanks. It's a lot clearer now. I assume that if I want to make
"timeofday" have a stable-behavior, I must enclose it in a sub-query. Am I
right?
--
Octavio Alvarez.
E-mail: alvarezp@alvarezp.ods.org.
Agradezco que sus correos sean enviados siempre a esta dirección.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: alvarezp@alvarezp.ods.org, jasiek@klaster.net
Subject: Re: [PERFORM] Seq scan on zero-parameters function
In-Reply-To: <3080.192.168.0.64.1076088292.squirrel@alvarezp.ods.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox