create or replace function createticket("auth" text, "ticketname" text, "issuetype" text, "devicetype" text ,"issuedetails" text, "priority" text)
returns void
language plpgsql
security definer set search_path = public
as $$
BEGIN
IF (checkifauth(auth)) THEN
insert into public.tickets (id, ticketname, issuetype, devicetype, issuedetails,priority)
values (new.id,new.ticketname,new.issuetype,new.devicetype,new.issuedetails,new.priority);
END IF;
END;
$$
create or replace function createticket("auth" text, "ticketname" text, "issuetype" text, "devicetype" text ,"issuedetails" text, "priority" text)
returns void
language plpgsql
security definer set search_path = public
as $$
BEGIN
IF (checkifauth(auth)) THEN
insert into public.tickets (id, ticketname, issuetype, devicetype, issuedetails,priority)
values (new.id,new.ticketname,new.issuetype,new.devicetype,new.issuedetails,new.priority);
END IF;
END;
$$