Re: function prepared plan

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Franco Bruno Borghesi <franco(at)akyasociados(dot)com(dot)ar>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: function prepared plan
Date: 2003-05-22 15:15:44
Message-ID: 19211.1053616544@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Franco Bruno Borghesi <franco(at)akyasociados(dot)com(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Franco Bruno Borghesi 2003-05-22 15:26:58 Re: function prepared plan
Previous Message Franco Bruno Borghesi 2003-05-22 15:04:11 Re: function prepared plan