Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f383BD858388 for ; Sat, 7 Apr 2001 23:11:13 -0400 (EDT) (envelope-from pgsql-sql-owner@postgresql.org) Received: from cheddar.netmonger.net (cheddar.netmonger.net [209.54.21.140]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f323HEK90012 for ; Sun, 1 Apr 2001 23:17:14 -0400 (EDT) (envelope-from chris@cheddar.netmonger.net) Received: (from chris@localhost) by cheddar.netmonger.net (8.8.8/8.8.8) id XAA04145; Sun, 1 Apr 2001 23:17:18 -0400 (EDT) Message-ID: <20010401231718.A1358@netmonger.net> Date: Sun, 1 Apr 2001 23:17:18 -0400 From: Christopher Masto To: pgsql-sql@postgresql.org Subject: Re: Trigger Function and Html Output Mail-Followup-To: pgsql-sql@postgresql.org References: <01040103502000.12630@devil.hades> <3AC758D6.41FDD33C@archonet.com> <01040113214300.13105@devil.hades> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.91.1i In-Reply-To: <01040113214300.13105@devil.hades>; from Stef Telford on Sun, Apr 01, 2001 at 01:21:43PM -0400 X-Archive-Number: 200104/107 X-Sequence-Number: 2453 On Sun, Apr 01, 2001 at 01:21:43PM -0400, Stef Telford wrote: > maybe i am naive in thinking this way, but surely the a database function > formatting the returned string must be quicker then perl. (speaking > generically of course, i conceed that there are times when the reverse > is true) Formatting data is not always so simple. You definately need to encode entities and such, and doing this from SQL could get to be a pain. Particularly when you decide that now you want this column to contain a link to some other page, or that rows should alternate colors, or whatever. Doing some of the work in the database is generally a good thing, but I think in this case it's just a hell of a lot easier in Perl because it's a more powerful language. -- Christopher Masto Senior Network Monkey NetMonger Communications chris@netmonger.net info@netmonger.net http://www.netmonger.net Free yourself, free your machine, free the daemon -- http://www.freebsd.org/