代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/376006/2718131
sql char.sql
--
-- CHAR
--
-- fixed-length by value
-- internally passed by value if
www.eeworm.com/read/376006/2718132
sql plancache.sql
--
-- Tests to exercise the plan caching/invalidation mechanism
--
CREATE TEMP TABLE pcachetest AS SELECT * FROM int8_tbl;
-- create and use a cached plan
PREPARE prepstmt AS SELECT * FROM pcachetes
www.eeworm.com/read/376006/2718136
sql inet.sql
--
-- INET
--
-- prepare the table...
DROP TABLE INET_TBL;
CREATE TABLE INET_TBL (c cidr, i inet);
INSERT INTO INET_TBL (c, i) VALUES ('192.168.1', '192.168.1.226/24');
INSERT INTO INET_TBL (c, i) V
www.eeworm.com/read/376006/2718137
sql random.sql
--
-- RANDOM
-- Test the random function
--
-- count the number of tuples originally, should be 1000
SELECT count(*) FROM onek;
-- pick three random rows, they shouldn't match
(SELECT unique1 AS ran
www.eeworm.com/read/376006/2718140
sql polymorphism.sql
-- Currently this tests polymorphic aggregates and indirectly does some
-- testing of polymorphic SQL functions. It ought to be extended.
-- Legend:
-----------
-- A = type is ANY
-- P = type is po
www.eeworm.com/read/376006/2718142
sql circle.sql
--
-- CIRCLE
--
CREATE TABLE CIRCLE_TBL (f1 circle);
INSERT INTO CIRCLE_TBL VALUES ('');
INSERT INTO CIRCLE_TBL VALUES ('');
INSERT INTO CIRCLE_TBL VALUES ('1,3,5');
INSERT IN
www.eeworm.com/read/376006/2718143
sql geometry.sql
--
-- GEOMETRY
--
-- Back off displayed precision a little bit to reduce platform-to-platform
-- variation in results.
SET extra_float_digits TO -3;
--
-- Points
--
SELECT '' AS four, center(f1) AS
www.eeworm.com/read/376006/2718144
sql cluster.sql
--
-- CLUSTER
--
CREATE TABLE clstr_tst_s (rf_a SERIAL PRIMARY KEY,
b INT);
CREATE TABLE clstr_tst (a SERIAL PRIMARY KEY,
b INT,
c TEXT,
d TEXT,
CONSTRAINT clstr_tst_con FOREIGN KEY (b) REFERE
www.eeworm.com/read/376006/2718148
sql rangefuncs.sql
SELECT name, setting FROM pg_settings WHERE name LIKE 'enable%';
CREATE TABLE foo2(fooid int, f2 int);
INSERT INTO foo2 VALUES(1, 11);
INSERT INTO foo2 VALUES(2, 22);
INSERT INTO foo2 VALUES(1, 111);
www.eeworm.com/read/376006/2718149
sql abstime.sql
--
-- ABSTIME
-- testing built-in time type abstime
-- uses reltime and tinterval
--
--
-- timezones may vary based not only on location but the operating
-- system. the main correctness issue is th