Untitled

mail@pastecode.io avatar
unknown
sql
a year ago
536 B
1
Indexable
Never
do $$
begin
if not exists (select "Id" from "NsSedAddressee" where "SfTerritorialAuthorityId" = '51a5523e-f606-45f3-a554-a6010715e346') then
	insert into "NsSedAddressee"("CreatedOn", "CreatedById", "ModifiedOn", "ModifiedById", "SfTerritorialAuthorityId", "NsMedoUserId", "NsMedoUserPass") values
	('2023-08-02 11:50:00.000', '410006e1-ca4e-4502-a9ec-e54d922d2c00', '2023-08-02 11:50:00.000', '410006e1-ca4e-4502-a9ec-e54d922d2c00', '51a5523e-f606-45f3-a554-a6010715e346', '10763312', '12345');
end if;
end;
$$ language PLPGSQL;