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 t1$t2$t3 (
codes int
);
CREATE TABLE
INSERT INTO t1$t2$t3 (codes)
VALUES
(100),
(100),
(007),
(100),
(004),
(004),
(000)
INSERT 0 7
select * from t1$t2$t3
| codes |
|---|
| 100 |
| 100 |
| 7 |
| 100 |
| 4 |
| 4 |
| 0 |
SELECT 7
CREATE PROCEDURE insert_data(a integer, b integer)
LANGUAGE SQL
BEGIN ATOMIC
INSERT INTO t1$t2$t3 VALUES (a);
INSERT INTO t1$t2$t3 VALUES (b);
END;
CREATE PROCEDURE
CALL insert_data(1, 2);
CALL
select * from t1$t2$t3
| codes |
|---|
| 100 |
| 100 |
| 7 |
| 100 |
| 4 |
| 4 |
| 0 |
| 1 |
| 2 |
SELECT 9