Received: from mailout00.sul.t-online.com (mailout00.sul.t-online.com [194.25.134.16]) by hub.org (8.10.1/8.10.1) with ESMTP id e61AjUS37783 for ; Sat, 1 Jul 2000 06:45:31 -0400 (EDT) Received: from fwd03.sul.t-online.com by mailout00.sul.t-online.com with smtp id 138Km5-0004IT-04; Sat, 1 Jul 2000 12:45:25 +0200 Received: from hot.jw.home (340000654369-0001@[62.224.103.18]) by fwd03.sul.t-online.com with esmtp id 138Klw-1ad3bMC; Sat, 1 Jul 2000 12:45:16 +0200 Received: (from wieck@localhost) by hot.jw.home (8.8.5/8.8.5) id LAA14484; Sat, 1 Jul 2000 11:03:43 +0200 From: JanWieck@t-online.de (Jan Wieck) Message-Id: <200007010903.LAA14484@hot.jw.home> Subject: Re: Which procedural language to use for functions. In-Reply-To: <7283DE19D141D111AD0E00A0C95B195503A59CFD@mail2.aiinet.com> from "Saltsgaver, Scott" at "Jun 30, 2000 05:22:07 pm" To: "Saltsgaver, Scott" Date: Sat, 1 Jul 2000 11:03:43 +0200 (MEST) CC: "Pgsql-Sql \\(E-mail\\)" Reply-To: Jan Wieck X-Mailer: ELM [version 2.4ME+ PL68 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Sender: 340000654369-0001@t-dialin.net X-Archive-Number: 200007/39 Saltsgaver, Scott wrote: > Which procedural language is best for writing PostgreSQL functions: > 'PL/pgSQL', 'PL/perl', or 'PL/Tcl'? > > I know that I can't do table creates in 'PL/pgSQL'? > > Is there an obvious choice as far speed and size? PL/Tcl has the advantage that it can do the table creates you want. OTOH if your frontend app is written in Perl, it's not that likely that one of the app programmers easily understands a function. I have no benchmarking information between the procedural languages. If that's really an issue, write your functions and triggers in C. Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com #