Thank you.
What clause is acceptable??
Bob
----- Original Message -----
From: "Jaime Casanova" <systemguards@xxxxxxxxx>
To: "Bob Pawley" <rjpawley@xxxxxxx>
Cc: "Postgre General" <pgsql-general@xxxxxxxxxxxxxx>
Sent: Tuesday, November 15, 2005 9:55 AM
Subject: Re: Is it databases in general, SQL or Postgresql?
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 6: explain analyze is your friend
