Lines Matching refs:test_complex
86 CREATE TABLE test_complex (
94 INSERT INTO test_complex VALUES ('(1.0, 2.5)', '(4.2, 3.55 )');
95 INSERT INTO test_complex VALUES ('(33.0, 51.4)', '(100.42, 93.55)');
97 SELECT * FROM test_complex;
123 SELECT (a + b) AS c FROM test_complex;
130 FROM test_complex;
147 SELECT complex_sum(a) FROM test_complex;
215 INSERT INTO test_complex VALUES ('(56.0,-22.5)', '(-43.2,-0.07)');
216 INSERT INTO test_complex VALUES ('(-91.9,33.6)', '(8.6,3.0)');
218 CREATE INDEX test_cplx_ind ON test_complex
221 SELECT * from test_complex where a = '(56.0,-22.5)';
222 SELECT * from test_complex where a < '(56.0,-22.5)';
223 SELECT * from test_complex where a > '(56.0,-22.5)';
227 DROP TABLE test_complex;