That works. Thanks very much.

Bob
----- Original Message ----- From: "Jaime Casanova" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "Alban Hertroys" <[EMAIL PROTECTED]>; "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 <[EMAIL PROTECTED]> 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 ;)

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to