On Mon, 21 Jan 2008 08:01:49 -0600 Russ Brown <pickscrape@xxxxxxxxx> wrote: > 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? It'd be very appreciated. I tried to read this: http://www.pgsql.cz/index.php/PL/pgSQL_(en)#When_is_PL.2FpgSQL_not_applicable But I'm not sure I really grasped it. Some comparison/examples more may help. BTW today pg 8.3-rc2 reached Debian sid amd64 and I took a chance to see what was available... and there is support for a *lot* of languages now. I started to develop a lot of functions code thinking that pgsql was the nearest thing to the metal after plain sql and after these post I was wondering if python (or ruby??) would have made a better choice. My main concern when I chose the function route was limiting the number of connections and hiding the underlying structure of the DB to the client application. -- Ivan Sergio Borgonovo http://www.webthatworks.it ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
