On 11/15/05, Bob Pawley <rjpawley@xxxxxxx> wrote:> create or replace function base() returns trigger as $$>> begin>> insert into pi (fluid_id) values (new.fluid_id)>> where pr (contain) = 'ip';>> return null;>> end;>> $$ language plpgsql;>> Error Message �>>>> ERROR: syntax error at or near "where" at character 41>> QUERY: insert into pi (fluid_id) values ( $1 ) where pr (contain) => 'ip'CONTEXT: PL/pgSQL function "base" line 2 at SQL statement this is SQL... the INSERT statement doesn't accept a WHERE clause --regards,Jaime Casanova(DBA: DataBase Aniquilator ;) ---------------------------(end of broadcast)---------------------------TIP 2: Don't 'kill -9' the postmaster
