Re: Functions in Postgres - Mailing list pgsql-sql

From Gordon Clarke
Subject Re: Functions in Postgres
Date
Msg-id Pine.LNX.4.21.0204120656530.30360-100000@localhost.localdomain
Whole thread Raw
In response to Re: Functions in Postgres  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-sql
On Wed, 10 Apr 2002, Peter Eisentraut wrote:

> Each language handler is free to interpret the source text in its own way.
> This has nothing to do with trustedness (is SQL not trusted?).  Neither
> PL/pgSQL nor PL/Tcl involve a compilation step, although PL/pgSQL does
> some optimizations internally that could be called compilation.
> 
> Is this question just out of random interest, or are you really asking
> something like are functions fast?

I was asking to see if there was any speed penalty with coding a fn in SQL
as opposed to PL/pgsql. It appears that there is and from what you've said
PL/pgsql is slightly faster than PL/TCL and probably PL/Perl. Am I correct
in drawing that conclusion?

Thanks for your help.

-- 
Cheers...Gordon
-------------+------------------------------------------------------------
ADF Aircraft | Cataloguing the serial numbers of Australian Defence Force  Serial    |            aircraft for all the
threeseries. Numbers    |               http://www.adf-serials.com
 
-------------+------------------------------------------------------------



pgsql-sql by date:

Previous
From: Jean-Michel POURE
Date:
Subject: Re: [GENERAL] Transactional vs. Read-only (Retrieval) database
Next
From: Richard Emberson
Date:
Subject: Re: [GENERAL] how to get more detailed error messages?