From: Pavel Stehule <pavel.stehule@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: Does IMMUTABLE property propagate?
Date: Thu, 25 Mar 2010 08:27:27 +0100
Message-ID: <162867791003250027q3cfc5ba9g59d56768aa4c4e5e@mail.gmail.com> (raw)
In-Reply-To: <20100325061616.GA4629@apartia.fr>
References: <4B91C184.4090906@venaver.info>
<407d949e1003060645i408e0648te67dfd722172f76a@mail.gmail.com>
<4B927FED.60209@venaver.info>
<4150.1267911115@sss.pgh.pa.us>
<20100325061616.GA4629@apartia.fr>
2010/3/25 Louis-David Mitterrand <vindex+lists-pgsql-sql@apartia.org>:
> On Sat, Mar 06, 2010 at 04:31:55PM -0500, Tom Lane wrote:
>> Petru Ghita <petrutz@venaver.info> writes:
>> > "..immediately replaced with the function value" doesn't mean that the
>> > results of a previously evaluated function for the same parameters are
>> > stored and reused?
>>
>> No, it means what it says: the function is executed once and replaced
>> with a constant representing the result value.
>
> So for example a function like:
>
>
> CREATE OR REPLACE FUNCTION shorten_cruise_type(intext text) RETURNS text
> AS $$
> declare
> outtext text;
> begin
> outtext = trim(regexp_replace(intext, E'\\s*Short( Break)?', '', 'i'));
> return outtext;
> end;
> $$
> LANGUAGE plpgsql;
>
yes it should be declared as immutable. plpgsql function is black box
for executor, so you have to use some flag. language sql is different,
executor see inside, so there you can not do it.
Regards
Pavel Stehule
> could/should be declared immutable?
>
> Thanks,
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>
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: pavel.stehule@gmail.com
Subject: Re: Does IMMUTABLE property propagate?
In-Reply-To: <162867791003250027q3cfc5ba9g59d56768aa4c4e5e@mail.gmail.com>
* 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