Re: SQL Functions vs PL/PgSQL

From: Tomasz Myrta <jasiek(at)klaster(dot)net>
To: Johnny Kristensen <johnnybo1(at)mail(dot)tele(dot)dk>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: SQL Functions vs PL/PgSQL
Date: 2003-02-13 09:21:35
Message-ID: 3E4B639F.1090703@klaster.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Johnny Kristensen wrote:
> Hi!
> 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,
> Johnny Kristensen
You need Postgresql 7.3 to do this. Check sql function "PREPARE".
Regards,
Tomasz Myrta

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Nicholas Allen 2003-02-13 09:40:49 Re: Possible bug in Postgres? Followup to "How do you select from a table until a condition is met?"
Previous Message Abdul Wahab Dahalan 2003-02-13 08:52:19 UNION or UNION ALL