I am attempting to generate a temporary function to execute some dml with
the following script:
create or replace function setuplicense() returns integer as $$
declare
hwcustid integer := 0;
retval integer := 0;
begin
insert into license.customer
( customer_id ) values ( hwcustid );
commit;
return retval;
end;
$$
LANGUAGE plpgsql;
select setuplicense();
When running this with psql I get the following:
Error: syntax error at or near "create"
Does anyone have a suggestion as to what is causing this?
Thanks