14 lines
455 B
Text
14 lines
455 B
Text
statement ok
|
|
CREATE TABLE mytable (one BIGINT NOT NULL, two BIGINT, PRIMARY KEY(one));
|
|
|
|
statement ok
|
|
CREATE INDEX mytable__idx__two_a ON mytable (two) NULLS NOT DISTINCT;
|
|
|
|
statement ok
|
|
CREATE INDEX mytable__idx__two_b ON public.mytable (two) NULLS NOT DISTINCT;
|
|
|
|
statement ok
|
|
CREATE TABLE myschema.anothertable (one BIGINT NOT NULL, two BIGINT, PRIMARY KEY(one));
|
|
|
|
statement ok
|
|
CREATE INDEX t1__idx__two ON myschema.anothertable (two) NULLS NOT DISTINCT;
|