Re: how to use record type
От | Jeff Eckermann |
---|---|
Тема | Re: how to use record type |
Дата | |
Msg-id | 009401c12727$71b3a150$279c10ac@INTERNAL обсуждение исходный текст |
Ответ на | Fwd: how to use record type (Horst Herb <hherb@malleenet.net.au>) |
Ответы |
Re: how to use record type
|
Список | pgsql-sql |
I have encountered this problem (in a different context), and could not find a way to insert entire rows/records in the way that you appear to want. But it worked fine if I INSERTed explicitly, like: INSERT INTO table VALUES (OLD.field1, OLD.field2, ..., OLD.fieldn); That should work fine inside a plpgsql function. ----- Original Message ----- From: "Horst Herb" <hherb@malleenet.net.au> To: <pgsql-novice@postgresql.org>; <pgsql-sql@postgresql.org> Sent: Thursday, August 16, 2001 5:24 PM Subject: Fwd: how to use record type > I have difficulties understanding how to use variable of "record" or "row" > type. How do I actually insert the variables OLD or NEW or a record type into > a table from within a trigger? > > Like doing the following: > > drop table th1; > create table th1( > id serial, > text text ); > > drop table th_audit; > create table th1_audit( > ts timestamp default now() > ) inherits(th1); > > drop function thaudit(); > create function thaudit() returns opaque as ' > begin > -- I want to insert OLD into th_audit - how do I do this??? > return NEW; > end; ' language 'plpgsql'; > > drop trigger ta on th1; > create trigger ta before delete or update on th1 > for each row execute procedure thaudit(); > > Reagrds, > Horst > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > >
В списке pgsql-sql по дате отправления: