CREATE PROCEDURE add_product (a INT, b TIMESTAMP, c VARCHAR(20), d VARCHAR(50), e INT, f INT)
AS $$
BEGIN
INSERT INTO sales (ID, Sale_time, Pharmacy, product, Number_of_packages, Price)
VALUES (a, b, c, d, e, f);
IF (a < 5) THEN
RAISE NOTICE 'перехватили ошибку 1', now();
END IF;
END;
$$ LANGUAGE plpgsql;
UPDATE userProfile
SET nick = 'вася'
WHERE userId = 522024879;
INSERT INTO userProfile (userid, nick)
SELECT 522024879, 'вася'
WHERE NOT EXISTS (SELECT 1 FROM userProfile WHERE userId =522024879);
Select g.Group as "итог",
sum(t.y) as "сумма"
From groups g
Join table t
On g.x = t.x
Group by g.Group