Re: function prepared plan - Mailing list pgsql-sql

From Tom Lane
Subject Re: function prepared plan
Date
Msg-id 19211.1053616544@sss.pgh.pa.us
Whole thread Raw
In response to Re: function prepared plan  (Franco Bruno Borghesi <franco@akyasociados.com.ar>)
Responses Re: function prepared plan  (Franco Bruno Borghesi <franco@akyasociados.com.ar>)
List pgsql-sql
Franco Bruno Borghesi <franco@akyasociados.com.ar> writes:
> Ok Tom, I'll try casting in the testSQL function like you said... but let me ask you another thing: 
> what is plpgsql exactily caching?

The plan for the "CAST(foo AS TEXT)" expression.  Under the hood that's
a SELECT CAST($1 AS TEXT), and it has a plan.
        regards, tom lane


pgsql-sql by date:

Previous
From: Franco Bruno Borghesi
Date:
Subject: Re: function prepared plan
Next
From: Franco Bruno Borghesi
Date:
Subject: Re: function prepared plan