Re: Inserting Data - Mailing list pgsql-general

From Merlin Moncure
Subject Re: Inserting Data
Date
Msg-id [email protected]
Whole thread Raw
In response to Inserting Data  (Bob Pawley <[email protected]>)
List pgsql-general
On 8/18/06, Bob Pawley <[email protected]> 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