Postgres Pro
Downloads
Home   >   mailing lists

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

From Tomasz Myrta
Subject Re: SQL Functions vs PL/PgSQL
Date
Msg-id 3E4B639F.1090703@klaster.net
Whole thread Raw
In response to SQL Functions vs PL/PgSQL  ("Johnny Kristensen" <johnnybo1@mail.tele.dk>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Nicholas Allen
Date:
Subject: Re: Possible bug in Postgres? Followup to "How do you select from a table until a condition is met?"
Next
From: Peter Childs
Date:
Subject: Re: Possible bug in Postgres? Followup to "How do you select