X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 847F9329ED3 for ; Tue, 19 Oct 2004 16:12:20 +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 26376-02 for ; Tue, 19 Oct 2004 15:12:18 +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 2F97A329EC2 for ; Tue, 19 Oct 2004 16:12:17 +0100 (BST) Received: (qmail 7360 invoked by uid 6002); 19 Oct 2004 15:17:10 -0000 Received: from 68.56.170.170 by ns2.instrumentalyst.com (envelope-from , 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.119687 secs); 19 Oct 2004 15:17:10 -0000 Received: from unknown (HELO ?192.168.2.2?) (68.56.170.170) by blk-222-55-203.eastlink.ca with SMTP; 19 Oct 2004 15:17:09 -0000 Message-ID: <41752EEF.4090902@productivitymedia.com> Date: Tue, 19 Oct 2004 11:12:47 -0400 From: Postgres User User-Agent: Mozilla Thunderbird 0.8 (Macintosh/20041019) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: SQL Functions References: <4142008A.2010108@productivitymedia.com> <4143408B.7040604@ca.afilias.info> <41742364.7070601@productivitymedia.com> <41742C60.8030602@commandprompt.com> <4174AC40.1010401@productivitymedia.com> In-Reply-To: <4174AC40.1010401@productivitymedia.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/230 X-Sequence-Number: 15223 What are the advantages to SQL Functions? I'm looking to optimize 'default' PostgreSQL environments for clients. I'm writing an application and looking to put functions to optimize just that table, etc. They don't want to have a full-time database admin (surprise!). Thanks, J