代码搜索:sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/183001/5258982
sql plperl.sql
--
-- checkpoint so that if we have a crash in the tests, replay of the
-- just-completed CREATE DATABASE won't discard the core dump file
--
checkpoint;
--
-- Test result value processing
--
CREATE
www.eeworm.com/read/183001/5260354
sql point.sql
--
-- POINT
--
CREATE TABLE POINT_TBL(f1 point);
INSERT INTO POINT_TBL(f1) VALUES ('(0.0,0.0)');
INSERT INTO POINT_TBL(f1) VALUES ('(-10.0,0.0)');
INSERT INTO POINT_TBL(f1) VALUES ('(-3.0,4.0)');
www.eeworm.com/read/183001/5260355
sql errors.sql
--
-- ERRORS
--
-- bad in postquel, but ok in postsql
select 1;
--
-- UNSUPPORTED STUFF
-- doesn't work
-- notify pg_class
--
--
-- SELECT
-- missing relation name
select;
-- no such relati
www.eeworm.com/read/183001/5260356
sql char.sql
--
-- CHAR
--
-- fixed-length by value
-- internally passed by value if
www.eeworm.com/read/183001/5260360
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/183001/5260361
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/183001/5260364
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/183001/5260366
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/183001/5260367
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/183001/5260368
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