Spracherkennung für: .out vermutete Sprache: Unknown {[0] [0] [0]} [Methode: Schwerpunktbildung, einfache Gewichte, sechs Dimensionen]
set enable_seqscan=off;
CREATE TABLE test_varbit (
i varbit
);
INSERT INTO test_varbit VALUES ('001'),('010'),('011'),('100'),('101'),('110');
CREATE INDEX idx_varbit ON test_varbit USING gin (i);
SELECT * FROM test_varbit WHERE i<'100'::varbit ORDER BY i;
i
-----
001
010
011
(3 rows)
SELECT * FROM test_varbit WHERE i<='100'::varbit ORDER BY i;
i
-----
001
010
011
100
(4 rows)
SELECT * FROM test_varbit WHERE i='100'::varbit ORDER BY i;
i
-----
100
(1 row)
SELECT * FROM test_varbit WHERE i>='100'::varbit ORDER BY i;
i
-----
100
101
110
(3 rows)
SELECT * FROM test_varbit WHERE i>'100'::varbit ORDER BY i;
i
-----
101
110
(2 rows)
[Dauer der Verarbeitung: 0.13 Sekunden, vorverarbeitet 2026-08-08]
