/dports/x11-toolkits/open-motif/motif-2.3.8/clients/uil/ |
H A D | UilSymNam.c | 123 *sym_find_name(l_length, c_text) in sym_find_name() argument 126 char *c_text; /* text of the name */ 135 l_hash_code = hash_function( l_length, c_text ); 148 l_compare_result = _compare(c_text, az_current_name->c_text); 216 sym_name_entry_type *sym_insert_name(l_length, c_text) in sym_insert_name() argument 219 char *c_text; /* text of the name */ 236 l_hash_code = hash_function( l_length, c_text ); 253 l_compare_result = _compare(c_text, az_current_name->c_text); 288 _move( az_new_name->c_text, c_text, l_length+1 ); 452 _debug_output("\t %s \n", az_name->c_text); in sym_dump_hash_table()
|
/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/expected/ |
H A D | fast_default.sql | 220 c_text, 402 c_text 415 c_text 424 c_text 437 c_text 469 c_text, 483 c_text, 496 c_text, 512 c_text, 534 c_text = '"' || c_text || '"' [all …]
|
/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/sql/ |
H A D | fast_default.sql | 84 ALTER TABLE T ADD COLUMN c_text TEXT DEFAULT 'world', 90 ALTER COLUMN c_text SET DEFAULT 'cat'; 147 ALTER COLUMN c_text DROP DEFAULT, 228 ALTER COLUMN c_text DROP DEFAULT, 282 SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 284 EXPLAIN (VERBOSE TRUE, COSTS FALSE) SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 293 SELECT SUM(c_bigint), MAX(c_text COLLATE "C" ), MIN(c_text COLLATE "C") FROM T; 313 UPDATE T SET c_text = '"' || c_text || '"' WHERE pk < 10; 314 SELECT * FROM T WHERE c_text LIKE '"%"' ORDER BY PK; 344 CREATE INDEX i ON T(c_int, c_text); [all …]
|
/dports/databases/postgresql11-docs/postgresql-11.14/src/test/regress/sql/ |
H A D | fast_default.sql | 84 ALTER TABLE T ADD COLUMN c_text TEXT DEFAULT 'world', 90 ALTER COLUMN c_text SET DEFAULT 'cat'; 147 ALTER COLUMN c_text DROP DEFAULT, 228 ALTER COLUMN c_text DROP DEFAULT, 282 SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 284 EXPLAIN (VERBOSE TRUE, COSTS FALSE) SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 293 SELECT SUM(c_bigint), MAX(c_text COLLATE "C" ), MIN(c_text COLLATE "C") FROM T; 313 UPDATE T SET c_text = '"' || c_text || '"' WHERE pk < 10; 314 SELECT * FROM T WHERE c_text LIKE '"%"' ORDER BY PK; 344 CREATE INDEX i ON T(c_int, c_text); [all …]
|
/dports/databases/postgresql11-plperl/postgresql-11.14/src/test/regress/sql/ |
H A D | fast_default.sql | 84 ALTER TABLE T ADD COLUMN c_text TEXT DEFAULT 'world', 90 ALTER COLUMN c_text SET DEFAULT 'cat'; 147 ALTER COLUMN c_text DROP DEFAULT, 228 ALTER COLUMN c_text DROP DEFAULT, 282 SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 284 EXPLAIN (VERBOSE TRUE, COSTS FALSE) SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 293 SELECT SUM(c_bigint), MAX(c_text COLLATE "C" ), MIN(c_text COLLATE "C") FROM T; 313 UPDATE T SET c_text = '"' || c_text || '"' WHERE pk < 10; 314 SELECT * FROM T WHERE c_text LIKE '"%"' ORDER BY PK; 344 CREATE INDEX i ON T(c_int, c_text); [all …]
|
/dports/databases/postgresql11-contrib/postgresql-11.14/src/test/regress/sql/ |
H A D | fast_default.sql | 84 ALTER TABLE T ADD COLUMN c_text TEXT DEFAULT 'world', 90 ALTER COLUMN c_text SET DEFAULT 'cat'; 147 ALTER COLUMN c_text DROP DEFAULT, 228 ALTER COLUMN c_text DROP DEFAULT, 282 SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 284 EXPLAIN (VERBOSE TRUE, COSTS FALSE) SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 293 SELECT SUM(c_bigint), MAX(c_text COLLATE "C" ), MIN(c_text COLLATE "C") FROM T; 313 UPDATE T SET c_text = '"' || c_text || '"' WHERE pk < 10; 314 SELECT * FROM T WHERE c_text LIKE '"%"' ORDER BY PK; 344 CREATE INDEX i ON T(c_int, c_text); [all …]
|
/dports/databases/postgresql11-client/postgresql-11.14/src/test/regress/sql/ |
H A D | fast_default.sql | 84 ALTER TABLE T ADD COLUMN c_text TEXT DEFAULT 'world', 90 ALTER COLUMN c_text SET DEFAULT 'cat'; 147 ALTER COLUMN c_text DROP DEFAULT, 228 ALTER COLUMN c_text DROP DEFAULT, 282 SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 284 EXPLAIN (VERBOSE TRUE, COSTS FALSE) SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 293 SELECT SUM(c_bigint), MAX(c_text COLLATE "C" ), MIN(c_text COLLATE "C") FROM T; 313 UPDATE T SET c_text = '"' || c_text || '"' WHERE pk < 10; 314 SELECT * FROM T WHERE c_text LIKE '"%"' ORDER BY PK; 344 CREATE INDEX i ON T(c_int, c_text); [all …]
|
/dports/databases/postgresql11-plpython/postgresql-11.14/src/test/regress/sql/ |
H A D | fast_default.sql | 84 ALTER TABLE T ADD COLUMN c_text TEXT DEFAULT 'world', 90 ALTER COLUMN c_text SET DEFAULT 'cat'; 147 ALTER COLUMN c_text DROP DEFAULT, 228 ALTER COLUMN c_text DROP DEFAULT, 282 SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 284 EXPLAIN (VERBOSE TRUE, COSTS FALSE) SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 293 SELECT SUM(c_bigint), MAX(c_text COLLATE "C" ), MIN(c_text COLLATE "C") FROM T; 313 UPDATE T SET c_text = '"' || c_text || '"' WHERE pk < 10; 314 SELECT * FROM T WHERE c_text LIKE '"%"' ORDER BY PK; 344 CREATE INDEX i ON T(c_int, c_text); [all …]
|
/dports/databases/postgresql12-client/postgresql-12.9/src/test/regress/sql/ |
H A D | fast_default.sql | 84 ALTER TABLE T ADD COLUMN c_text TEXT DEFAULT 'world', 90 ALTER COLUMN c_text SET DEFAULT 'cat'; 147 ALTER COLUMN c_text DROP DEFAULT, 228 ALTER COLUMN c_text DROP DEFAULT, 282 SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 284 EXPLAIN (VERBOSE TRUE, COSTS FALSE) SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 293 SELECT SUM(c_bigint), MAX(c_text COLLATE "C" ), MIN(c_text COLLATE "C") FROM T; 313 UPDATE T SET c_text = '"' || c_text || '"' WHERE pk < 10; 314 SELECT * FROM T WHERE c_text LIKE '"%"' ORDER BY PK; 344 CREATE INDEX i ON T(c_int, c_text); [all …]
|
/dports/databases/postgresql11-pltcl/postgresql-11.14/src/test/regress/sql/ |
H A D | fast_default.sql | 84 ALTER TABLE T ADD COLUMN c_text TEXT DEFAULT 'world', 90 ALTER COLUMN c_text SET DEFAULT 'cat'; 147 ALTER COLUMN c_text DROP DEFAULT, 228 ALTER COLUMN c_text DROP DEFAULT, 282 SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 284 EXPLAIN (VERBOSE TRUE, COSTS FALSE) SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 293 SELECT SUM(c_bigint), MAX(c_text COLLATE "C" ), MIN(c_text COLLATE "C") FROM T; 313 UPDATE T SET c_text = '"' || c_text || '"' WHERE pk < 10; 314 SELECT * FROM T WHERE c_text LIKE '"%"' ORDER BY PK; 344 CREATE INDEX i ON T(c_int, c_text); [all …]
|
/dports/databases/postgresql14-pltcl/postgresql-14.1/src/test/regress/sql/ |
H A D | fast_default.sql | 84 ALTER TABLE T ADD COLUMN c_text TEXT DEFAULT 'world', 90 ALTER COLUMN c_text SET DEFAULT 'cat'; 147 ALTER COLUMN c_text DROP DEFAULT, 228 ALTER COLUMN c_text DROP DEFAULT, 282 SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 284 EXPLAIN (VERBOSE TRUE, COSTS FALSE) SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 293 SELECT SUM(c_bigint), MAX(c_text COLLATE "C" ), MIN(c_text COLLATE "C") FROM T; 313 UPDATE T SET c_text = '"' || c_text || '"' WHERE pk < 10; 314 SELECT * FROM T WHERE c_text LIKE '"%"' ORDER BY PK; 344 CREATE INDEX i ON T(c_int, c_text); [all …]
|
/dports/databases/postgresql14-plperl/postgresql-14.1/src/test/regress/sql/ |
H A D | fast_default.sql | 84 ALTER TABLE T ADD COLUMN c_text TEXT DEFAULT 'world', 90 ALTER COLUMN c_text SET DEFAULT 'cat'; 147 ALTER COLUMN c_text DROP DEFAULT, 228 ALTER COLUMN c_text DROP DEFAULT, 282 SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 284 EXPLAIN (VERBOSE TRUE, COSTS FALSE) SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 293 SELECT SUM(c_bigint), MAX(c_text COLLATE "C" ), MIN(c_text COLLATE "C") FROM T; 313 UPDATE T SET c_text = '"' || c_text || '"' WHERE pk < 10; 314 SELECT * FROM T WHERE c_text LIKE '"%"' ORDER BY PK; 344 CREATE INDEX i ON T(c_int, c_text); [all …]
|
/dports/databases/postgresql14-server/postgresql-14.1/src/test/regress/sql/ |
H A D | fast_default.sql | 84 ALTER TABLE T ADD COLUMN c_text TEXT DEFAULT 'world', 90 ALTER COLUMN c_text SET DEFAULT 'cat'; 147 ALTER COLUMN c_text DROP DEFAULT, 228 ALTER COLUMN c_text DROP DEFAULT, 282 SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 284 EXPLAIN (VERBOSE TRUE, COSTS FALSE) SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 293 SELECT SUM(c_bigint), MAX(c_text COLLATE "C" ), MIN(c_text COLLATE "C") FROM T; 313 UPDATE T SET c_text = '"' || c_text || '"' WHERE pk < 10; 314 SELECT * FROM T WHERE c_text LIKE '"%"' ORDER BY PK; 344 CREATE INDEX i ON T(c_int, c_text); [all …]
|
/dports/databases/postgresql14-plpython/postgresql-14.1/src/test/regress/sql/ |
H A D | fast_default.sql | 84 ALTER TABLE T ADD COLUMN c_text TEXT DEFAULT 'world', 90 ALTER COLUMN c_text SET DEFAULT 'cat'; 147 ALTER COLUMN c_text DROP DEFAULT, 228 ALTER COLUMN c_text DROP DEFAULT, 282 SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 284 EXPLAIN (VERBOSE TRUE, COSTS FALSE) SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 293 SELECT SUM(c_bigint), MAX(c_text COLLATE "C" ), MIN(c_text COLLATE "C") FROM T; 313 UPDATE T SET c_text = '"' || c_text || '"' WHERE pk < 10; 314 SELECT * FROM T WHERE c_text LIKE '"%"' ORDER BY PK; 344 CREATE INDEX i ON T(c_int, c_text); [all …]
|
/dports/databases/postgresql14-docs/postgresql-14.1/src/test/regress/sql/ |
H A D | fast_default.sql | 84 ALTER TABLE T ADD COLUMN c_text TEXT DEFAULT 'world', 90 ALTER COLUMN c_text SET DEFAULT 'cat'; 147 ALTER COLUMN c_text DROP DEFAULT, 228 ALTER COLUMN c_text DROP DEFAULT, 282 SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 284 EXPLAIN (VERBOSE TRUE, COSTS FALSE) SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 293 SELECT SUM(c_bigint), MAX(c_text COLLATE "C" ), MIN(c_text COLLATE "C") FROM T; 313 UPDATE T SET c_text = '"' || c_text || '"' WHERE pk < 10; 314 SELECT * FROM T WHERE c_text LIKE '"%"' ORDER BY PK; 344 CREATE INDEX i ON T(c_int, c_text); [all …]
|
/dports/databases/postgresql13-plpython/postgresql-13.5/src/test/regress/sql/ |
H A D | fast_default.sql | 84 ALTER TABLE T ADD COLUMN c_text TEXT DEFAULT 'world', 90 ALTER COLUMN c_text SET DEFAULT 'cat'; 147 ALTER COLUMN c_text DROP DEFAULT, 228 ALTER COLUMN c_text DROP DEFAULT, 282 SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 284 EXPLAIN (VERBOSE TRUE, COSTS FALSE) SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 293 SELECT SUM(c_bigint), MAX(c_text COLLATE "C" ), MIN(c_text COLLATE "C") FROM T; 313 UPDATE T SET c_text = '"' || c_text || '"' WHERE pk < 10; 314 SELECT * FROM T WHERE c_text LIKE '"%"' ORDER BY PK; 344 CREATE INDEX i ON T(c_int, c_text); [all …]
|
/dports/databases/postgresql14-contrib/postgresql-14.1/src/test/regress/sql/ |
H A D | fast_default.sql | 84 ALTER TABLE T ADD COLUMN c_text TEXT DEFAULT 'world', 90 ALTER COLUMN c_text SET DEFAULT 'cat'; 147 ALTER COLUMN c_text DROP DEFAULT, 228 ALTER COLUMN c_text DROP DEFAULT, 282 SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 284 EXPLAIN (VERBOSE TRUE, COSTS FALSE) SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 293 SELECT SUM(c_bigint), MAX(c_text COLLATE "C" ), MIN(c_text COLLATE "C") FROM T; 313 UPDATE T SET c_text = '"' || c_text || '"' WHERE pk < 10; 314 SELECT * FROM T WHERE c_text LIKE '"%"' ORDER BY PK; 344 CREATE INDEX i ON T(c_int, c_text); [all …]
|
/dports/databases/postgresql13-pltcl/postgresql-13.5/src/test/regress/sql/ |
H A D | fast_default.sql | 84 ALTER TABLE T ADD COLUMN c_text TEXT DEFAULT 'world', 90 ALTER COLUMN c_text SET DEFAULT 'cat'; 147 ALTER COLUMN c_text DROP DEFAULT, 228 ALTER COLUMN c_text DROP DEFAULT, 282 SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 284 EXPLAIN (VERBOSE TRUE, COSTS FALSE) SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 293 SELECT SUM(c_bigint), MAX(c_text COLLATE "C" ), MIN(c_text COLLATE "C") FROM T; 313 UPDATE T SET c_text = '"' || c_text || '"' WHERE pk < 10; 314 SELECT * FROM T WHERE c_text LIKE '"%"' ORDER BY PK; 344 CREATE INDEX i ON T(c_int, c_text); [all …]
|
/dports/databases/postgresql14-client/postgresql-14.1/src/test/regress/sql/ |
H A D | fast_default.sql | 84 ALTER TABLE T ADD COLUMN c_text TEXT DEFAULT 'world', 90 ALTER COLUMN c_text SET DEFAULT 'cat'; 147 ALTER COLUMN c_text DROP DEFAULT, 228 ALTER COLUMN c_text DROP DEFAULT, 282 SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 284 EXPLAIN (VERBOSE TRUE, COSTS FALSE) SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 293 SELECT SUM(c_bigint), MAX(c_text COLLATE "C" ), MIN(c_text COLLATE "C") FROM T; 313 UPDATE T SET c_text = '"' || c_text || '"' WHERE pk < 10; 314 SELECT * FROM T WHERE c_text LIKE '"%"' ORDER BY PK; 344 CREATE INDEX i ON T(c_int, c_text); [all …]
|
/dports/databases/postgresql13-server/postgresql-13.5/src/test/regress/sql/ |
H A D | fast_default.sql | 84 ALTER TABLE T ADD COLUMN c_text TEXT DEFAULT 'world', 90 ALTER COLUMN c_text SET DEFAULT 'cat'; 147 ALTER COLUMN c_text DROP DEFAULT, 228 ALTER COLUMN c_text DROP DEFAULT, 282 SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 284 EXPLAIN (VERBOSE TRUE, COSTS FALSE) SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 293 SELECT SUM(c_bigint), MAX(c_text COLLATE "C" ), MIN(c_text COLLATE "C") FROM T; 313 UPDATE T SET c_text = '"' || c_text || '"' WHERE pk < 10; 314 SELECT * FROM T WHERE c_text LIKE '"%"' ORDER BY PK; 344 CREATE INDEX i ON T(c_int, c_text); [all …]
|
/dports/databases/postgresql13-contrib/postgresql-13.5/src/test/regress/sql/ |
H A D | fast_default.sql | 84 ALTER TABLE T ADD COLUMN c_text TEXT DEFAULT 'world', 90 ALTER COLUMN c_text SET DEFAULT 'cat'; 147 ALTER COLUMN c_text DROP DEFAULT, 228 ALTER COLUMN c_text DROP DEFAULT, 282 SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 284 EXPLAIN (VERBOSE TRUE, COSTS FALSE) SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 293 SELECT SUM(c_bigint), MAX(c_text COLLATE "C" ), MIN(c_text COLLATE "C") FROM T; 313 UPDATE T SET c_text = '"' || c_text || '"' WHERE pk < 10; 314 SELECT * FROM T WHERE c_text LIKE '"%"' ORDER BY PK; 344 CREATE INDEX i ON T(c_int, c_text); [all …]
|
/dports/databases/postgresql11-server/postgresql-11.14/src/test/regress/sql/ |
H A D | fast_default.sql | 84 ALTER TABLE T ADD COLUMN c_text TEXT DEFAULT 'world', 90 ALTER COLUMN c_text SET DEFAULT 'cat'; 147 ALTER COLUMN c_text DROP DEFAULT, 228 ALTER COLUMN c_text DROP DEFAULT, 282 SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 284 EXPLAIN (VERBOSE TRUE, COSTS FALSE) SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 293 SELECT SUM(c_bigint), MAX(c_text COLLATE "C" ), MIN(c_text COLLATE "C") FROM T; 313 UPDATE T SET c_text = '"' || c_text || '"' WHERE pk < 10; 314 SELECT * FROM T WHERE c_text LIKE '"%"' ORDER BY PK; 344 CREATE INDEX i ON T(c_int, c_text); [all …]
|
/dports/databases/postgresql12-server/postgresql-12.9/src/test/regress/sql/ |
H A D | fast_default.sql | 84 ALTER TABLE T ADD COLUMN c_text TEXT DEFAULT 'world', 90 ALTER COLUMN c_text SET DEFAULT 'cat'; 147 ALTER COLUMN c_text DROP DEFAULT, 228 ALTER COLUMN c_text DROP DEFAULT, 282 SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 284 EXPLAIN (VERBOSE TRUE, COSTS FALSE) SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 293 SELECT SUM(c_bigint), MAX(c_text COLLATE "C" ), MIN(c_text COLLATE "C") FROM T; 313 UPDATE T SET c_text = '"' || c_text || '"' WHERE pk < 10; 314 SELECT * FROM T WHERE c_text LIKE '"%"' ORDER BY PK; 344 CREATE INDEX i ON T(c_int, c_text); [all …]
|
/dports/databases/postgresql13-client/postgresql-13.5/src/test/regress/sql/ |
H A D | fast_default.sql | 84 ALTER TABLE T ADD COLUMN c_text TEXT DEFAULT 'world', 90 ALTER COLUMN c_text SET DEFAULT 'cat'; 147 ALTER COLUMN c_text DROP DEFAULT, 228 ALTER COLUMN c_text DROP DEFAULT, 282 SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 284 EXPLAIN (VERBOSE TRUE, COSTS FALSE) SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 293 SELECT SUM(c_bigint), MAX(c_text COLLATE "C" ), MIN(c_text COLLATE "C") FROM T; 313 UPDATE T SET c_text = '"' || c_text || '"' WHERE pk < 10; 314 SELECT * FROM T WHERE c_text LIKE '"%"' ORDER BY PK; 344 CREATE INDEX i ON T(c_int, c_text); [all …]
|
/dports/databases/postgresql12-docs/postgresql-12.9/src/test/regress/sql/ |
H A D | fast_default.sql | 84 ALTER TABLE T ADD COLUMN c_text TEXT DEFAULT 'world', 90 ALTER COLUMN c_text SET DEFAULT 'cat'; 147 ALTER COLUMN c_text DROP DEFAULT, 228 ALTER COLUMN c_text DROP DEFAULT, 282 SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 284 EXPLAIN (VERBOSE TRUE, COSTS FALSE) SELECT c_bigint, c_text FROM T WHERE c_text = 'hello' LIMIT 1; 293 SELECT SUM(c_bigint), MAX(c_text COLLATE "C" ), MIN(c_text COLLATE "C") FROM T; 313 UPDATE T SET c_text = '"' || c_text || '"' WHERE pk < 10; 314 SELECT * FROM T WHERE c_text LIKE '"%"' ORDER BY PK; 344 CREATE INDEX i ON T(c_int, c_text); [all …]
|