[ADMIN] EXECUTE plpgsql

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 * fro

Re: [ADMIN] EXECUTE plpgsql

Julio Leyva <[EMAIL PROTECTED]> writes: > Hi allI'm trying to get the next value from a sequence using a store proced= > ure like thiscreate or replace function givemenext() returns integer AS $$= > DECLAREnewvalue integer;getseq varchar(256);BEGINreturn EXECUTE 'SELECT nex= > tval(''test_id_seq''