3
-- test retrieval of min/max keys for each index
12
WHERE b.seqno >= 9999;
20
WHERE b.seqno < '1'::name;
24
WHERE b.seqno >= '9999'::name;
28
WHERE b.seqno = '4500'::name;
32
WHERE b.seqno < '1'::text;
36
WHERE b.seqno >= '9999'::text;
40
WHERE b.seqno = '4500'::text;
44
WHERE b.seqno < '1'::float8;
48
WHERE b.seqno >= '9999'::float8;
52
WHERE b.seqno = '4500'::float8;
55
-- Check correct optimization of LIKE (special index operator support)
56
-- for both indexscan and bitmapscan cases
59
set enable_seqscan to false;
60
set enable_indexscan to true;
61
set enable_bitmapscan to false;
62
select proname from pg_proc where proname like E'RI\\_FKey%del' order by 1;
64
set enable_indexscan to false;
65
set enable_bitmapscan to true;
66
select proname from pg_proc where proname like E'RI\\_FKey%del' order by 1;