Functions in postgres

From: Kris Kiger <kris(at)musicrebellion(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Functions in postgres
Date: 2003-05-01 22:20:02
Message-ID: 3EB19D92.6050400@musicrebellion.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hey all, here's a question that I think can be easily answered by those
of you with more experience than I. What are the
advantages/disadvantages of using a function with postgres as opposed to
putting all of the SQL in an external file (a web page for example)?
The only advantages that I can see is that if you want to isolate an
entire process or want to associate a trigger with it, you can. Also, I
suppose it could cut down on a bit of network traffic by sending only
the needed variables rather than the entire query. Aside from this
however, does it offer any kind of performance increase (ie stored query
plan, pre-compiled, etc)? Thanks for the insite

Kris

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Trevor Astrope 2003-05-01 22:24:03 The database system is in recovery mode
Previous Message Marc Mitchell 2003-05-01 21:51:47 Type casting and indexes: bug?