X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 49C1432AEBB
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 20 Oct 2004 03:40:49 +0100 (BST)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 53798-02
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 20 Oct 2004 02:40:36 +0000 (GMT)
Received: from ns2.instrumentalyst.com (blk-222-55-203.eastlink.ca
	[24.222.55.203])
	by svr1.postgresql.org (Postfix) with SMTP id EE1E832AEB5
	for <pgsql-sql@postgresql.org>; Wed, 20 Oct 2004 03:40:39 +0100 (BST)
Received: (qmail 15619 invoked by uid 6002); 20 Oct 2004 02:45:30 -0000
Received: from 68.56.170.170 by ns2.instrumentalyst.com (envelope-from
	<postgres@productivitymedia.com>, uid 4002) with qmail-scanner-1.23
	(clamdscan: 0.75.1. spamassassin: 3.0.0.  
	Clear:RC:1(68.56.170.170):.
	Processed in 0.124512 secs); 20 Oct 2004 02:45:30 -0000
Received: from unknown (HELO ?192.168.2.2?) (68.56.170.170)
	by blk-222-55-203.eastlink.ca with SMTP; 20 Oct 2004 02:45:30 -0000
Message-ID: <4175D047.3080307@productivitymedia.com>
Date: Tue, 19 Oct 2004 22:41:11 -0400
From: Postgres User <postgres@productivitymedia.com>
User-Agent: Mozilla Thunderbird 0.8 (Macintosh/20041019)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Which type of functions are best?
References: <416C74CC.6030309@dri.edu>
	<9E1E7300-2215-11D9-A5E5-000D93AE0944@sitening.com>
	<41759C78.1040101@onesystem.com> <41759DA4.6070803@onesystem.com>
In-Reply-To: <41759DA4.6070803@onesystem.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=
X-Spam-Level: 
X-Archive-Number: 200410/136
X-Sequence-Number: 19239

Hi,

I'm just starting out and am looking to speed up queries using either 
SQL functions or PLPGSQL functions.  I have googled around and have not 
found a great answer saying that this is the way to go.  I would like to 
use PREPARE/EXECUTE... but of course they only last for each connection, 
I would like something more permanent.

Thanks for your input,
J