X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 43538475A80
	for <pgsql-sql@postgresql.org>; Wed, 12 Feb 2003 16:48:15 -0500 (EST)
Received: from pfepb.post.tele.dk (pfepb.post.tele.dk [193.162.153.3])
	by postgresql.org (Postfix) with ESMTP id A87CC4759BD
	for <pgsql-sql@postgresql.org>; Wed, 12 Feb 2003 16:48:14 -0500 (EST)
Received: from johnny (0x50c49adc.adsl-fixed.tele.dk [80.196.154.220])
	by pfepb.post.tele.dk (Postfix) with SMTP id 2C4065EE0A3
	for <pgsql-sql@postgresql.org>; Wed, 12 Feb 2003 22:48:14 +0100 (CET)
Message-ID: <000801c2d2e0$edd32420$dc9ac450@johnny>
From: "Johnny Kristensen" <johnnybo1@mail.tele.dk>
To: <pgsql-sql@postgresql.org>
Subject: SQL Functions vs PL/PgSQL
Date: Wed, 12 Feb 2003 22:51:41 +0100
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0005_01C2D2E9.4F24F430"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200302/271
X-Sequence-Number: 11669

This is a multi-part message in MIME format.

------=_NextPart_000_0005_01C2D2E9.4F24F430
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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 do=
cs!?
Thanks,
Johnny Kristensen

------=_NextPart_000_0005_01C2D2E9.4F24F430
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2600.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi!</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Does postgres store execution plan's for=
=20
user-defined SQL functions as the PL/pgSQL interpreter does. And if so - wi=
ll=20
this only be prepared after an initial call&nbsp;to the function?&nbsp;Can'=
t=20
seem to&nbsp;find&nbsp;this information&nbsp;in the docs!?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Thanks,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Johnny Kristensen</FONT></DIV></BODY></HTM=
L>

------=_NextPart_000_0005_01C2D2E9.4F24F430--