Postgres 14

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 TYPE happy_enum AS ENUM ('happy', 'very happy', 'ecstatic');
CREATE DOMAIN happy_domain AS TEXT CHECK ( VALUE IN ('happy', 'very happy', 'ecstatic') );
CREATE TABLE holidays (
    some_happy_enum happy_enum,
    some_happy_domain happy_domain,
    some_happy_text text
);
INSERT INTO holidays(some_happy_enum, some_happy_domain, some_happy_text)
VALUES ('happy', 'happy', 'happy');
1 rows affected

INSERT INTO holidays(some_happy_enum, some_happy_domain, some_happy_text)
VALUES ('sad', 'sad', 'sad');
ERROR:  invalid input value for enum happy_enum: "sad"
LINE 2: VALUES ('sad', 'sad', 'sad');
                ^


CREATE FUNCTION test(input text) 
    RETURNS BOOLEAN 
    AS 'SELECT true;' 
    LANGUAGE SQL;
SELECT test(some_happy_enum) FROM holidays;
ERROR:  function test(happy_enum) does not exist
LINE 1: SELECT test(some_happy_enum) FROM holidays;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.


SELECT test(some_happy_domain) FROM holidays;


test


t


SELECT test(some_happy_text) FROM holidays;


test


t