Thread: Learning pl/pgsql - good sources?

Learning pl/pgsql - good sources?

From
simon@villages.co.uk (simon)
Date:
Hello All,

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?

Best regards

Simon

Re: Learning pl/pgsql - good sources?

From
Josh Berkus
Date:
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

Re: Learning pl/pgsql - good sources?

From
Kaarel
Date:
>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?
>
Have you already checked these links?

http://www.postgresql.org/docs/aw_pgsql_book/node165.html
http://www.commandprompt.com/ppbook/c19610.htm