From: Tomasz Myrta <jasiek@klaster.net>
To: alvarezp@alvarezp.ods.org, Lista dyskusyjna pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: [PERFORM] Seq scan on zero-parameters function
Date: Fri, 06 Feb 2004 09:55:26 +0100
Message-ID: <4023567E.1020406@klaster.net> (raw)
In-Reply-To: <4795.192.168.0.64.1076056992.squirrel@alvarezp.ods.org>
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>
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?
Look at function now(). It returns always the same value inside
transaction. If your current_period_id() works the same way as now()
then declare it as STABLE.
Regards,
Tomasz Myrta
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: jasiek@klaster.net
Subject: Re: [PERFORM] Seq scan on zero-parameters function
In-Reply-To: <4023567E.1020406@klaster.net>
* 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