Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 00D68632A29 for ; Thu, 25 Mar 2010 13:06:11 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 31446-04 for ; Thu, 25 Mar 2010 16:06:00 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-pz0-f185.google.com (mail-pz0-f185.google.com [209.85.222.185]) by mail.postgresql.org (Postfix) with ESMTP id 4B3B7632942 for ; Thu, 25 Mar 2010 13:06:00 -0300 (ADT) Received: by pzk15 with SMTP id 15so1296079pzk.29 for ; Thu, 25 Mar 2010 09:05:58 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:sender:received:in-reply-to :references:from:date:x-google-sender-auth:message-id:subject:to:cc :content-type; bh=1epggV+wEaDExuVGUB//OlhlWc7cLop/hOUXdCMMrc0=; b=qUmumelVEf1jOhBADB0cAKPFflSmj4DUcF7bKTqiNYksKT2Uv6qi/h8l1spwXIIN9a LkOlfmbaSHXRF5qT4QrbnKTU+6CaRZFJKGbN/V6TBnt+Cjpt4BUlC7gFg93Y9/efoZxX apFGG1FJXf9g4rRE2XCQ678317+Zf0obUFYSU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:sender:in-reply-to:references:from:date :x-google-sender-auth:message-id:subject:to:cc:content-type; b=tAt6mFCWsM9LXYYtpiIznn4xC5pDXQEHtojyIkUqJG/s5FeKNd426Uc1n7HzCxW07c taUBs+WIPDppXXbmTlLetWP+xNGwu+Iw0dnqWULDy4je5brIzHwBRyaubcQWsI0wQzTC ztIOdfYMTQTliFODofWA7unlG3MYyFBwBTyQM= MIME-Version: 1.0 Received: by 10.141.107.7 with SMTP id j7mr5811623rvm.71.1269533154672; Thu, 25 Mar 2010 09:05:54 -0700 (PDT) In-Reply-To: <16800.1269527726@sss.pgh.pa.us> References: <4B91C184.4090906@venaver.info> <407d949e1003060645i408e0648te67dfd722172f76a@mail.gmail.com> <4B927FED.60209@venaver.info> <4150.1267911115@sss.pgh.pa.us> <20100325061616.GA4629@apartia.fr> <162867791003250027q3cfc5ba9g59d56768aa4c4e5e@mail.gmail.com> <20100325075405.GA17176@apartia.fr> <16800.1269527726@sss.pgh.pa.us> From: Greg Stark Date: Thu, 25 Mar 2010 16:05:34 +0000 X-Google-Sender-Auth: f746435fb7f16ee8 Message-ID: <407d949e1003250905m323c6959wd07b0d7310cd271c@mail.gmail.com> Subject: Re: Does IMMUTABLE property propagate? To: Tom Lane Cc: Louis-David Mitterrand , pgsql-sql@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201003/187 X-Sequence-Number: 33894 On Thu, Mar 25, 2010 at 2:35 PM, Tom Lane wrote: > When you're intending to have a SQL function be inlined, it's probably > best not to mark it as either IMMUTABLE or STRICT --- that doesn't buy > anything and it can complicate matters as to whether inlining is legal. I'm confused, I thought it was volatile and strict that prevented inlining. -- greg