EXECUTE plpgsql

From: Julio Leyva <jcleyva(at)hotmail(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: EXECUTE plpgsql
Date: 2007-08-11 15:34:18
Message-ID: BAY120-W44E61B77A185D9588610CA1E20@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2007-08-11 16:04:58 Re: EXECUTE plpgsql
Previous Message Julio Cesar Sánchez González 2007-08-11 02:22:20 Re: Joining tables in two different databases?