Re: Is it databases in general, SQL or Postgresql?

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 ;)
>