Re: Does IMMUTABLE property propagate?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Petru Ghita <petrutz(at)venaver(dot)info>
Cc: Greg Stark <stark(at)mit(dot)edu>, pgsql-sql mailing list <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Does IMMUTABLE property propagate?
Date: 2010-03-06 21:31:55
Message-ID: 4150.1267911115@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Petru Ghita <petrutz(at)venaver(dot)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.

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message query 2010-03-08 12:25:23 list of all months
Previous Message Andreas Kretschmer 2010-03-06 17:17:05 Re: Drop all constraints