代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/183001/5260412
sql privileges.sql
--
-- Test access privileges
--
CREATE USER regressuser1;
CREATE USER regressuser2;
CREATE USER regressuser3;
CREATE USER regressuser4;
CREATE USER regressuser4; -- duplicate
CREATE GROUP regressgro
www.eeworm.com/read/183001/5260413
sql oidjoins.sql
--
-- This is created by pgsql/contrib/findoidjoins/make_oidjoin_check
--
SELECT ctid, aggfnoid
FROM pg_catalog.pg_aggregate fk
WHERE aggfnoid != 0 AND
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc
www.eeworm.com/read/183001/5260415
sql strings.sql
--
-- STRINGS
-- Test various data entry syntaxes.
--
-- SQL92 string continuation syntax
-- E021-03 character string literals
SELECT 'first line'
' - next line'
' - third line'
AS "Three lines to
www.eeworm.com/read/183001/5260416
sql join.sql
--
-- JOIN
-- Test JOIN clauses
--
CREATE TABLE J1_TBL (
i integer,
j integer,
t text
);
CREATE TABLE J2_TBL (
i integer,
k integer
);
INSERT INTO J1_TBL VALUES (1, 4, 'one');
INSERT INT
www.eeworm.com/read/183001/5260417
sql inherit.sql
--
-- Test inheritance features
--
CREATE TABLE a (aa TEXT);
CREATE TABLE b (bb TEXT) INHERITS (a);
CREATE TABLE c (cc TEXT) INHERITS (a);
CREATE TABLE d (dd TEXT) INHERITS (b,c,a);
INSERT INTO a(aa)
www.eeworm.com/read/183001/5260419
sql select_into.sql
--
-- SELECT_INTO
--
SELECT *
INTO TABLE tmp1
FROM onek
WHERE onek.unique1 < 2;
DROP TABLE tmp1;
SELECT *
INTO TABLE tmp1
FROM onek2
WHERE onek2.unique1 < 2;
DROP TABLE tmp1;
www.eeworm.com/read/183001/5260420
sql rules.sql
--
-- RULES
-- From Jan's original setup_ruletest.sql and run_ruletest.sql
-- - thomas 1998-09-13
--
--
-- Tables and rules for the view test
--
create table rtest_t1 (a int4, b int4);
create table r
www.eeworm.com/read/183001/5260422
sql transactions.sql
--
-- TRANSACTIONS
--
BEGIN;
SELECT *
INTO TABLE xacttest
FROM aggtest;
INSERT INTO xacttest (a, b) VALUES (777, 777.777);
END;
-- should retrieve one value--
SELECT a FROM xacttest WHERE
www.eeworm.com/read/183001/5260423
sql prepare.sql
-- Regression tests for prepareable statements
PREPARE q1 AS SELECT 1;
EXECUTE q1;
-- should fail
PREPARE q1 AS SELECT 2;
-- should succeed
DEALLOCATE q1;
PREPARE q1 AS SELECT 2;
EXECUTE q1;
-- sq
www.eeworm.com/read/183001/5260424
sql sequence.sql
---
--- test creation of SERIAL column
---
CREATE TABLE serialTest (f1 text, f2 serial);
INSERT INTO serialTest VALUES ('foo');
INSERT INTO serialTest VALUES ('bar');
INSERT INTO serialTest VALUES