On Jul 3, 2007, at 6:48 PM, Julio Leyva wrote:
create or replace function updatesafe() returns integer AS $$
DECLARE
maxseq integer;
alterseq varchar(256);
thumb integer;
newvalue integer;
BEGIN
newvalue := 10010;
maxseq := (select max(safeoperationid) from safeopencloseoperation);
if (
From: Julio Leyva <[EMAIL PROTECTED]>
To:
Subject: [ADMIN] alter sequence in a function
Date: Tue, 3 Jul 2007 22:48:30 +
Hi allI'm trying to create a function that alters a sequenceThis what I'm
doingcreate or replace function updatesafe() returns integer AS
$$DECLA
Hi allI'm trying to create a function that alters a sequenceThis what I'm
doingcreate or replace function updatesafe() returns integer AS
$$DECLAREmaxseq integer;alterseq varchar(256);thumb integer;newvalue
integer;BEGINnewvalue := 10010; maxseq := (select max(safeoperationid) from
safeopenc
