Where I can find PL/pgSQL and Trigger Examples?

From: Alessandro Bottoni <alessandro(dot)bottoni(at)infinito(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: Where I can find PL/pgSQL and Trigger Examples?
Date: 2003-04-18 07:43:53
Message-ID: 200304180943.53171.alessandro.bottoni@infinito.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm in the need (for the first time in my life) to intercept an UPDATE
operation (before it is executed) and use its parameters to perform an
equivalent INSERT operation on the same table (of course on a different row).
This small trigger is required to bybass a small bug in a third-party program
I'm using for my work.

I checked both "Postgres: introduction and concepts" and "Practical Postgres"
for examples (as well as the User's and Developer's guides of Postgres) but
I'm still confused by the PL/pgSQL sintax and by the "quotes puzzle". As a
consequence, I'm looking for real-world/working examples of Triggers and
PL/pgPSQL (in particular, examples that performs INSERT operation with
variables values).

Is there anything like a repository of PL/pgSQL examples on the Net? I mean:
something like the "cookbooks" published by ActiveState
(ASPN.activestate.com). Where I can find a (possibly _huge_) collection of
PL/pgSQL programs?

Many thanks for your attention.

---------------------
Alessandro Bottoni

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Benjamin RICHARD 2003-04-18 08:16:11 Problem with the use of Array and Loop
Previous Message Network Administrator 2003-04-18 07:42:27 Re: 7.3 PDF documentation