Re: Functions in Postgres
От | Gordon Clarke |
---|---|
Тема | Re: Functions in Postgres |
Дата | |
Msg-id | Pine.LNX.4.21.0204120656530.30360-100000@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: Functions in Postgres (Peter Eisentraut <peter_e@gmx.net>) |
Список | 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 по дате отправления: