Re: Trigger Function and Html Output

From: Christopher Masto <chris(at)netmonger(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Trigger Function and Html Output
Date: 2001-04-02 03:17:18
Message-ID: 20010401231718.A1358@netmonger.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)netmonger(dot)net info(at)netmonger(dot)net http://www.netmonger.net

Free yourself, free your machine, free the daemon -- http://www.freebsd.org/

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Sharmad Naik 2001-04-02 07:22:18 passing parameters between forms
Previous Message J.Fernando Moyano 2001-04-02 02:44:00 very very slow .....