Thank you.
What clause is acceptable??
Bob
----- Original Message -----
From: "Jaime Casanova" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "Postgre General" <[email protected]>
Sent: Tuesday, November 15, 2005 9:55 AM
Subject: Re: [GENERAL] Is it databases in general, SQL or Postgresql?
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 6: explain analyze is your friend
