On Sun, 2003-10-19 at 22:51, Ling Xiaoyu wrote:
> Hello there.
> Can anybody help me with Postgresql triggers?
> what I need is a trigger which update value of field
> "tables_rows.total_rows" to rows count of table
> "zzz" if I insert new row in table "zzz"...
>
> CREATE TABLE zzz (
> ...
>
Quite a few people (including me) have had problems with creating triggers.
Last week Jan gave us the definative answer.
No,
trigger procedures in Postgres are allways defined to take no
arguments and have a return type "opaque".
The main error above is, that the "sql" language c