Re: Is it databases in general, SQL or Postgresql?
От | Bob Pawley |
---|---|
Тема | Re: Is it databases in general, SQL or Postgresql? |
Дата | |
Msg-id | 00a801c5ea0d$f2c33140$ac1d4318@OWNER обсуждение исходный текст |
Ответ на | Is it databases in general, SQL or Postgresql? (Bob Pawley <rjpawley@shaw.ca>) |
Ответы |
Re: Is it databases in general, SQL or Postgresql?
|
Список | pgsql-general |
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 ;) >
В списке pgsql-general по дате отправления: