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

On 11/15/05, Bob Pawley <rjpawley(at)shaw(dot)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 ;)