Re: Is it databases in general, SQL or Postgresql? - Mailing list pgsql-general

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