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