ERROR: syntax error at or near "select" at character 9
| От | Graf László |
|---|---|
| Тема | ERROR: syntax error at or near "select" at character 9 |
| Дата | |
| Msg-id | 4317FE8C.7020803@axis.hu обсуждение исходный текст |
| Ответы |
Re: ERROR: syntax error at or near "select" at character 9
|
| Список | pgsql-sql |
Hi
I am using PG 8.0 on Win32, learning SQL.
I dod create a table with the following SQL:
CREATE TABLE test ( id integer, nev varchar(25), datum timestamp );
A sequence with:
CREATE SEQUENCE "public"."test_azon_seq" INCREMENT 1 MINVALUE 101 MAXVALUE 9223372036854775807 START 101
CACHE 1 ;
A before insert trigger:
CREATE FUNCTION test_verif() RETURNS trigger AS $test_verif$ BEGIN NEW.id := select
nextval('test_azon_seq'); NEW.nev := nev; NEW.datum := current_timestamp; RETURN NEW;
END; $test_verif$ LANGUAGE plpgsql ;
CREATE TRIGGER test_verif BEFORE INSERT ON test FOR EACH ROW EXECUTE PROCEDURE test_verif() ;
When I issue the
insert into "public"."test" (nev) values ('Graf László');
insert statement, it returns
"ERROR: syntax error at or near "select" at character 9".
Why? What is wrong?
--
László Graf
В списке pgsql-sql по дате отправления: