procnum,

format_type_be(opclassform->opcintype))));

fmgr_info(funcid,&key->partsupfunc[i]);

fmgr_info_cxt(funcid,&key->partsupfunc[i],partkeycxt);

key->partcollation[i]=collation->values[i];

Partition constraint: ((abs(a) IS NOT NULL) AND (abs(b) IS NOT NULL) AND (c IS NOT NULL) AND ((abs(a) > 6) OR ((abs(a) = 6) AND (abs(b) >= 8))) AND (abs(a) <= 9))

DROP TABLE range_parted4;

-- user-defined operator class in partition key

CREATE FUNCTION my_int4_sort(int4,int4) RETURNS int LANGUAGE sql

AS $$ SELECT CASE WHEN $1 = $2 THEN 0 WHEN $1 > $2 THEN 1 ELSE -1 END; $$;

CREATE OPERATOR CLASS test_int4_ops FOR TYPE int4 USING btree AS

OPERATOR 1 < (int4,int4), OPERATOR 2 <= (int4,int4),

OPERATOR 3 = (int4,int4), OPERATOR 4 >= (int4,int4),

OPERATOR 5 > (int4,int4), FUNCTION 1 my_int4_sort(int4,int4);

CREATE TABLE partkey_t (a int4) PARTITION BY RANGE (a test_int4_ops);

CREATE TABLE partkey_t_1 PARTITION OF partkey_t FOR VALUES FROM (0) TO (1000);

INSERT INTO partkey_t VALUES (100);

INSERT INTO partkey_t VALUES (200);

-- cleanup

DROP TABLE parted, list_parted, range_parted, list_parted2, range_parted2, range_parted3;

DROP TABLE hash_parted;

DROP TABLE hash_parted2;

DROP TABLE partkey_t, hash_parted, hash_parted2;

DROP OPERATOR CLASS test_int4_ops USING btree;

DROP FUNCTION my_int4_sort(int4,int4);

-- comments on partitioned tables columns

CREATE TABLE parted_col_comment (a int, b text) PARTITION BY LIST (a);

COMMENT ON TABLE parted_col_comment IS 'Am partitioned table';

\d+ range_parted4_3

DROPTABLE range_parted4;

CREATEFUNCTIONmy_int4_sort(int4,int4) RETURNSint LANGUAGE sql

AS $$SELECT CASE WHEN $1= $2 THEN0 WHEN $1> $2 THEN1 ELSE-1 END; $$;

CREATEOPERATOR CLASStest_int4_ops FOR TYPE int4 USING btreeAS

OPERATOR1< (int4,int4), OPERATOR2<= (int4,int4),

OPERATOR3= (int4,int4), OPERATOR4>= (int4,int4),

OPERATOR5> (int4,int4), FUNCTION1 my_int4_sort(int4,int4);

CREATETABLEpartkey_t (a int4) PARTITION BY RANGE (a test_int4_ops);

CREATETABLEpartkey_t_1 PARTITION OF partkey_t FORVALUESFROM (0) TO (1000);

INSERT INTO partkey_tVALUES (100);

INSERT INTO partkey_tVALUES (200);

DROPTABLE parted, list_parted, range_parted, list_parted2, range_parted2, range_parted3;

DROPTABLE hash_parted;

DROPTABLE hash_parted2;

DROPTABLE partkey_t, hash_parted, hash_parted2;

DROPOPERATOR CLASS test_int4_ops USING btree;

DROPFUNCTION my_int4_sort(int4,int4);

CREATETABLEparted_col_comment (aint, btext) PARTITION BY LIST (a);