Hi allI'm trying to get the next value from a sequence using a store procedure 
like thiscreate or replace function givemenext()  returns integer AS 
$$DECLAREnewvalue integer;getseq varchar(256);BEGINreturn EXECUTE 'SELECT 
nextval(''test_id_seq'')';END;$$ language plpgsqlSo when I do select * from 
givemenext()I got this error messageERROR:  type "execute" does not 
existCONTEXT:  SQL statement "SELECT  EXECUTE 'SELECT 
nextval(''test_id_seq'')'"PL/pgSQL function "givemenext" line 11 at returnWhat 
I'm doing wrong?Thanks in advance

Reply via email to