On 11/15/05, Bob Pawley <[EMAIL PROTECTED]> 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
