Merlin Moncure wrote:
> On Jan 21, 2008 2:47 AM, Alex Turner <armtuk@gmail.com> wrote:
> In other words, pl/pgsql's speed disadvantages only matter if a
> significant portion of the work is in doing things other than
> executing queries and handling the results. Certainly, these types of
> problems come up, but such cases are simply out of the scope of the
> intended purpose of the language and there are many techniques dealing
> with these problems. On the other hand, pl/pgsql is extremely easy to
> write and debug, especially when running static sql. IMO, it is an
> absolute must for any PostgreSQL DBA to master the language as well as
> be aware of its limitations.
>
> merlin
>
Perhaps it would be useful to have a page in the documentation that
provides a brief comparison between the available pl languages
(including plpgsql and sql) and gives suggestions on the best one (or
ones) for given use cases?
--
Russ.