Thank you.
What clause is acceptable??
Bob
----- Original Message -----
From: "Jaime Casanova" <systemguards@gmail.com>
To: "Bob Pawley" <rjpawley@shaw.ca>
Cc: "Postgre General" <pgsql-general@postgresql.org>
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 <rjpawley@shaw.ca> 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 ;)
>
