That works. Thanks very much.
Bob
----- Original Message -----
From: "Jaime Casanova" <systemguards@gmail.com>
To: "Bob Pawley" <rjpawley@shaw.ca>
Cc: "Alban Hertroys" <alban@magproductions.nl>; "Postgres General"
<pgsql-general@postgresql.org>
Sent: Tuesday, November 15, 2005 11:36 AM
Subject: Re: [GENERAL] Is it databases in general, SQL or Postgresql?
On 11/15/05, Bob Pawley <rjpawley@shaw.ca> wrote:
> No - I mean when each row of pr (contain) has 'ip' inserted as a value or
> data.
>
> Bob
>
create or replace function base() returns trigger as $$
begin
if new.contain = 'ip' then
insert into pi (fluid_id) values (new.fluid_id);
end if;
return null;
end;
$$ language plpgsql;
--
Atentamente,
Jaime Casanova
(DBA: DataBase Aniquilator ;)