Re: how to evaluate a function only once for a query? - Mailing list pgsql-general

From Tom Lane
Subject Re: how to evaluate a function only once for a query?
Date
Msg-id 11688.1024581108@sss.pgh.pa.us
Whole thread Raw
In response to Re: how to evaluate a function only once for a query?  (Nicolae Mihalache <mache@abcpages.com>)
List pgsql-general
Nicolae Mihalache <mache@abcpages.com> writes:
> robust=# create function testfunc () returns text as '' language 'pltcl'
> with iscachable;
> ERROR:  parser: parse error at or near "iscachable"

I think it's
    with (iscachable);
    with (iscachable, isstrict);
etc

            regards, tom lane

pgsql-general by date:

Previous
From: "Bjoern Metzdorf"
Date:
Subject: Re: db grows and grows
Next
From: Tom Lane
Date:
Subject: Re: how to evaluate a function only once for a query?