Re: function prepared plan

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

That's great! I'll cast everything then.

Thanks Tom.

On Thursday 22 May 2003 12:15, Tom Lane wrote:
> 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

Browse pgsql-sql by date

  From Date Subject
Next Message Benoît Bournon 2003-05-22 15:46:25 tablename as attribute in pgplsql
Previous Message Tom Lane 2003-05-22 15:15:44 Re: function prepared plan