Good resources for learning PL/pgSQL?

sql postgresql plpgsql
mikl picture mikl · Aug 18, 2009 · Viewed 14.4k times · Source

I've been looking around the net trying to find good resources for learning PostgreSQL's procedural programming language, PL/pgSQL.

So far the only thing I've managed to dig up is the tutorial in the PostgreSQL documentation. While that is good, I've been looking for something more in-depth. Can you recommend anything?

Answer

Greg Smith picture Greg Smith · Aug 18, 2009

The best free intro to use along the official docs is at PL/pgSQL and its associated tricks page of non-trivial examples, although the translation is a bit rough in spots. More useful examples can be found rooting through the snippets page.

There are also decent chapters on PL/pgSQL inside "PostgreSQL Developer's Handbook" by Geschwinde/Schonig and "PostgreSQL" by Korry Douglas, both of which are a bit gentler intro to the language than the official docs. Those are both excellent general PostgreSQL books you might find useful for other reasons too.

Related questions

PostgreSQL IF statement

How can I do such query in Postgres? IF (select count(*) from orders) > 0 THEN DELETE from orders ELSE INSERT INTO orders values (1,2,3);

Read More
How to return result of a SELECT inside a function in PostgreSQL?

I have this function in PostgreSQL, but I don't know how to return the result of the query: CREATE OR REPLACE FUNCTION wordFrequency(maxTokens INTEGER) RETURNS SETOF RECORD AS $$ BEGIN SELECT text, count(*), 100 / maxTokens * count(*) FROM ( SELECT text FROM token …

Read More
Return multiple fields as a record in PostgreSQL with PL/pgSQL

I am writing a SP, using PL/pgSQL. I want to return a record, comprised of fields from several different tables. Could look something like this: CREATE OR REPLACE FUNCTION get_object_fields(name text) RETURNS RECORD AS $$ BEGIN -- …

Read More