By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
CREATE TABLE data$$1(
codes int
);
CREATE TABLE
INSERT INTO data$$1(codes)
VALUES
(100),
(100),
(007),
(100),
(004),
(004),
(000)
INSERT 0 7
select * from data$$1
| codes |
|---|
| 100 |
| 100 |
| 7 |
| 100 |
| 4 |
| 4 |
| 0 |
SELECT 7
CREATE PROCEDURE insert_data(a integer, b integer)
LANGUAGE SQL
BEGIN ATOMIC
INSERT INTO data$$1 VALUES (a);
INSERT INTO data$$1 VALUES (b);
END;
CREATE PROCEDURE
CALL insert_data(1, 2);
CALL
select * from data$$1
| codes |
|---|
| 100 |
| 100 |
| 7 |
| 100 |
| 4 |
| 4 |
| 0 |
| 1 |
| 2 |
SELECT 9