CREATE TABLE b (begt datetime, kid int4); CREATE TABLE a (kid int4); CREATE TABLE c (a int4, b varchar(30), c int4); CREATE INDEX b_0 on b using btree ( begt datetime_ops ); CREATE INDEX b_1 on b using btree ( kid int4_ops ); CREATE INDEX a_0 on a using btree ( kid int4_ops );