Postgres 11

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 udt AS (a text, b text)

CREATE TYPE


CREATE OR REPLACE FUNCTION abc() RETURNS text AS $BODY$
DECLARE
  x udt;
  y udt[];
BEGIN
  x := ROW(“a”,”b”)::udt;
  y := y || x;
  y := array_append(y,x);
  y := array_cat(y,ARRAY[x]);
END
$BODY$ LANGUAGE ‘plpgsql’
VOLATILE;

ERROR:  language "‘plpgsql’" does not exist


SELECT abc();

ERROR:  function abc() does not exist
LINE 1: SELECT abc();
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.