firstDismay

--Найти уникальные маршруты прямой-обратный и без обратных и отобразить только прямые
CREATE TABLE IF NOT EXISTS unique_couples
(
    point1 text,
    point2 text
);

INSERT INTO unique_couples VALUES('1','2');
INSERT INTO unique_couples VALUES('1','2');
INSERT INTO unique_couples VALUES('2','1');

firstDismay

CREATE OR REPLACE FUNCTION py_export_to_excel(
	command_export text)
    RETURNS bytea
    LANGUAGE 'plpython3u'
    COST 100
    VOLATILE PARALLEL UNSAFE
AS $BODY$
	'''Функция Python 3.7.4'''
	'''Дата: 29.05.2020 / 26.11.2020'''
	'''Версия: 1.2'''

firstDismay

-- Copyright 2019-2022 Jonathan S. Katz
-- 
-- MIT License
--
-- Permission is hereby granted, free of charge, to any person obtaining a copy
-- of this software and associated documentation files (the "Software"), to deal
-- in the Software without restriction, including without limitation the rights
-- to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
-- copies of the Software, and to permit persons to whom the Software is
-- furnished to do so, subject to the following conditions: