Avatar

Level 3

Dear All

 

I'm getting the below error while executing the script in admin console. could you please help me on this.

 

Thanks in Advance

 

ukender_0-1598281222354.png

SELECT CreateSequenceIfNecessary('NeoCustomId', '1000', 'cache 1000');

create or replace function GetNeoCustomId() returns integer as '
declare
iId integer;
begin
select into iId NextVal(''NeoCustomId'');
return iId;
end;
' language plpgsql
;
create or replace function GetNewNeoCustomIds(integer) returns text as '
declare
strIds text;
i integer;
iId integer;
begin
strIds = '''';
for i in 1 .. $1 loop
select NextVal(''NeoCustomId'') into iId ;
if i > 1 then
strIds := strIds || '','';
end if;
strIds := strIds || cast(iId as text);
end loop;
return strIds;
end;
' language plpgsql
;