trigger-procedure without plpgsql

On Fri, Feb 01, 2002 at 02:24:41PM +0100, Picrate wrote:

Hi all,

I!m having a hard time getting out well with trigger-procedures
without using plpgsql. I cannot put a hand on some documentation about
writing procedures in LANGUAGE 'sql'. There must be some info
somewhere, isn't it?

Everybody would have a hard time in this case. It's simply impossible
with plain SQL. Use PLPGSQL.

The docs you need are the chapters 20. and 23. of PostgreSQL
documentation.

I am trying to make a procedure which can update a table as reaction
to an insert into another table. For that, I need to get the id of the
table to update but I can't get it in any way because I don't know how
to call it. The "new.id_table_to_update" doesn't seem to be recognized
(the "new" term into the 'sql' procedure doesn't seem to be the right
syntax to reference it).

NEW works only in PLPGSQL not in SQL.

I would like to use 'sql' language for that 'cause I don't see any
interest in doing it with plpgsql if I can do it without it.

You cannot.

If someone could help... or at least mention some place where to
learn how to do this, I would be very glad.

Read the docs cited above or look under techdocs.postgresql.org, there
should be plenty examples.

--
Holger Krug
hkrug@rationalizer.com