Simon,
> I've recently made the transition to PostgreSQL from MySQL - and am
> trying to learn how to program functions using pl/pgsql - but todate
> have not found any really excellent examples in one place - can anyone
> advise me of somewhere a comprehensive set of examples can be found
> that I can learn from?
Poke around techdocs.postgresql.org.
Also, check out:
http://www.brasileiro.net/postgres/cookbook/
The cookbook is rather out of date (nothing since early 2002) but it's better
than nothing.
--
Josh Berkus
Aglio Database Solutions
San Francisco