3
-- test retrieval of min/max keys for each index
15
WHERE b.seqno >= 9999;
31
WHERE b.seqno < '1'::name;
39
WHERE b.seqno >= '9999'::name;
47
WHERE b.seqno = '4500'::name;
55
WHERE b.seqno < '1'::text;
63
WHERE b.seqno >= '9999'::text;
71
WHERE b.seqno = '4500'::text;
79
WHERE b.seqno < '1'::float8;
87
WHERE b.seqno >= '9999'::float8;
95
WHERE b.seqno = '4500'::float8;
102
-- Check correct optimization of LIKE (special index operator support)
103
-- for both indexscan and bitmapscan cases
105
set enable_seqscan to false;
106
set enable_indexscan to true;
107
set enable_bitmapscan to false;
108
select proname from pg_proc where proname like E'RI\\_FKey%del' order by 1;
110
------------------------
114
RI_FKey_setdefault_del
118
set enable_indexscan to false;
119
set enable_bitmapscan to true;
120
select proname from pg_proc where proname like E'RI\\_FKey%del' order by 1;
122
------------------------
126
RI_FKey_setdefault_del