Re: SQL Functions vs PL/PgSQL - Mailing list pgsql-sql

From Josh Berkus
Subject Re: SQL Functions vs PL/PgSQL
Date
Msg-id 200302130902.05987.josh@agliodbs.com
Whole thread Raw
In response to SQL Functions vs PL/PgSQL  ("Johnny Kristensen" <johnnybo1@mail.tele.dk>)
Responses Re: SQL Functions vs PL/PgSQL  (Roberto Mello <rmello@cc.usu.edu>)
List pgsql-sql
Johnny,

> Does postgres store execution plan's for user-defined SQL functions as the
> PL/pgSQL interpreter does. And if so - will this only be prepared after an
> initial call to the function? Can't seem to find this information in the
> docs!? Thanks,

Unless you know something I don't, I do not believe that PL/pgSQL stores
execution plans for functions.

--
Josh Berkus
Aglio Database Solutions
San Francisco


pgsql-sql by date:

Previous
From: "V. Cekvenich"
Date:
Subject: table Pivot
Next
From: Nicholas Allen
Date:
Subject: Re: Debugging postmaster to fix possible bug in Postgres? Followup to "How do you select