%ROWTYPE and insert - Mailing list pgsql-sql

From Larry Rosenman
Subject %ROWTYPE and insert
Date
Msg-id 106230000.1052496655@lerlaptop.iadfw.net
Whole thread Raw
List pgsql-sql
If I have a trigger that needs to write both the old and new rows, as well 
as additional
columns, can I use a %ROWTYPE variable on the end of the insert in 
PL/pgSQL?

Thanks,
LER


-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749



pgsql-sql by date:

Previous
From: "SZŰCS Gábor"
Date:
Subject: Re: "too clever" when creating SQL functions
Next
From: Manfred Koizar
Date:
Subject: Re: does this require a stored procedure?