Best way to learn PostgreSQL stored procedures?

Question

Is there a good tutorial or something similar for learning how to write Stored Procedures (for a PostgreSQL database). I'm a definite newbie when it comes to writing Stored Procedures at all, so the clearer and simpler things are explained, the better...

Thanks in advance...

score 27 · Accepted Answer · edited Jun 05 '12 at 08:30

27

You almost had it, but better start here plpgsql

Some will point that PL/pgSQL is not the only way to write Stored Procedures for PostgreSQL and they will be right (that's one of the advantages of Postgres), but on the other hand PL/pgSQL is nice and relatively easy to start with.

edited Jun 05 '12 at 08:30

PresleyDias

3,657
6
36
62

answered Mar 09 '09 at 15:10

Milen A. Radev

60,241
22
105
110

score 2 · Answer 2 · edited Jun 05 '12 at 08:29

2

Note that obviously, here's a good place to start:sql-createfunction

edited Jun 05 '12 at 08:29

PresleyDias

3,657
6
36
62

answered Mar 09 '09 at 08:23

Epaga

38,231
58
157
245

Best way to learn PostgreSQL stored procedures?

2 Answers2

Linked