Merlin Moncure wrote: > On Jan 21, 2008 2:47 AM, Alex Turner <armtuk@xxxxxxxxx> 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. ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/