Message-ID: <4317FE8C.7020803@axis.hu>
Date: Fri, 02 Sep 2005 09:26:04 +0200
From: =?ISO-8859-2?Q?Graf_L=E1szl=F3?= <graf.laszlo@axis.hu>
User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716)
MIME-Version: 1.0
To: pgsql-sql@postgresql.org, peter_e@gmx.net
Subject: ERROR:  syntax error at or near "select" at character 9
Content-Type: text/plain; charset=ISO-8859-2; format=flowed
Content-Transfer-Encoding: 8bit

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