On Fri, 2 Sep 2005, [ISO-8859-2] Graf L?szl? wrote: > > CREATE FUNCTION test_verif() RETURNS trigger AS $test_verif$ > BEGIN > NEW.id := select nextval('test_azon_seq');
I think you want to remove select here, you're already effectively doing a select of the right hand side in the assignment. > NEW.nev := nev; I think you want to remove this line entirely. What nev were you expecting on the right hand side? If it's the new one, well, NEW.new is already that. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster