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
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 |