Re: how to use record type - Mailing list pgsql-sql

From Jeff Eckermann
Subject Re: how to use record type
Date
Msg-id 009401c12727$71b3a150$279c10ac@INTERNAL
Whole thread Raw
In response to Fwd: how to use record type  (Horst Herb <hherb@malleenet.net.au>)
Responses Re: how to use record type
List 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 by date:

Previous
From: Morgan Curley
Date:
Subject: Query Approach and performance
Next
From: Oleg Lebedev
Date:
Subject: Re: Nested JOINs - upgrade to 7.1.2