代码搜索:sql

找到约 10,000 项符合「sql」的源代码

代码结果 10,000
www.eeworm.com/read/376006/2718176

sql bit.sql

-- -- BIT types -- -- -- Build tables for testing -- CREATE TABLE BIT_TABLE(b BIT(11)); INSERT INTO BIT_TABLE VALUES (B'10'); -- too short INSERT INTO BIT_TABLE VALUES (B'00000000000'); INSERT INTO
www.eeworm.com/read/376006/2718177

sql boolean.sql

-- -- BOOLEAN -- -- -- sanity check - if this fails go insane! -- SELECT 1 AS one; -- ******************testing built-in type bool******************** -- check bool type-casting as well as and, or
www.eeworm.com/read/376006/2718179

sql aggregates.sql

-- -- AGGREGATES -- SELECT avg(four) AS avg_1 FROM onek; SELECT avg(a) AS avg_32 FROM aggtest WHERE a < 100; -- In 7.1, avg(float4) is computed using float8 arithmetic. -- Round the result to 3 dig
www.eeworm.com/read/376006/2718180

sql oid.sql

-- -- OID -- CREATE TABLE OID_TBL(f1 oid); INSERT INTO OID_TBL(f1) VALUES ('1234'); INSERT INTO OID_TBL(f1) VALUES ('1235'); INSERT INTO OID_TBL(f1) VALUES ('987'); INSERT INTO OID_TBL(f1) VALUES ('
www.eeworm.com/read/376006/2718182

sql path.sql

-- -- PATH -- --DROP TABLE PATH_TBL; CREATE TABLE PATH_TBL (f1 path); INSERT INTO PATH_TBL VALUES ('[(1,2),(3,4)]'); INSERT INTO PATH_TBL VALUES ('((1,2),(3,4))'); INSERT INTO PATH_TBL VALUES ('[
www.eeworm.com/read/376006/2718183

sql plpgsql.sql

-- -- PLPGSQL -- -- Scenario: -- -- A building with a modern TP cable installation where any -- of the wall connectors can be used to plug in phones, -- ethernet interfaces or local offic
www.eeworm.com/read/376006/2718184

sql drop.sql

-- -- drop.source -- -- -- this will fail if the user is not the postgres superuser. -- if it does, don't worry about it (you can turn usersuper -- back on as "postgres"). too many people don't foll
www.eeworm.com/read/376006/2718185

sql box.sql

-- -- BOX -- -- -- box logic -- o -- 3 o--|X -- | o| -- 2 +-+-+ | -- | | | | -- 1 | o-+-o -- | | -- 0 +---+ -- -- 0 1 2 3 -- -- boxes are specified by two points, given by four floats x1
www.eeworm.com/read/376006/2718186

sql text.sql

-- -- TEXT -- SELECT text 'this is a text string' = text 'this is a text string' AS true; SELECT text 'this is a text string' = text 'this is a text strin' AS false; CREATE TABLE TEXT_TBL (f1 text)
www.eeworm.com/read/376006/2718187

sql timestamp.sql

-- -- TIMESTAMP -- CREATE TABLE TIMESTAMP_TBL (d1 timestamp(2) without time zone); -- Test shorthand input values -- We can't just "select" the results since they aren't constants; test for -- equal