Re: Inserting Data - Mailing list pgsql-general

From Merlin Moncure
Subject Re: Inserting Data
Date
Msg-id b42b73150608181916j3c2be0fg8b3da8f03e5196f@mail.gmail.com
Whole thread Raw
In response to Inserting Data  (Bob Pawley <rjpawley@shaw.ca>)
List pgsql-general
On 8/18/06, Bob Pawley <rjpawley@shaw.ca> wrote:
> Unfortunately this gave multiple results on the target tables.
>
> Is there a format that will give me a single insert for each original field
> without the need of creating three triggers???
>
> Bob

try using old/new in your trigger functions.

insert into table (targetfield) new.field;

merlin

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Query optimization and indexes
Next
From: Michael Fuhr
Date:
Subject: Re: Inserting Data