代码搜索：OUT
找到约 10,000 项符合「OUT」的源代码
代码结果 10,000
www.eeworm.com/read/376006/2718078
out varchar.out
--
-- VARCHAR
--
CREATE TABLE VARCHAR_TBL(f1 varchar(1));
INSERT INTO VARCHAR_TBL (f1) VALUES ('a');
INSERT INTO VARCHAR_TBL (f1) VALUES ('A');
-- any of the following three input formats are acceptab
www.eeworm.com/read/376006/2718079
out boolean.out
--
-- BOOLEAN
--
--
-- sanity check - if this fails go insane!
--
SELECT 1 AS one;
one
-----
1
(1 row)
-- ******************testing built-in type bool********************
-- check bool type-cast
www.eeworm.com/read/376006/2718081
out comments.out
--
-- COMMENTS
--
SELECT 'trailing' AS first; -- trailing single line
first
----------
trailing
(1 row)
SELECT /* embedded single line */ 'embedded' AS second;
second
----------
embedded
(
www.eeworm.com/read/376006/2718083
out transactions.out
--
-- 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 a > 1
www.eeworm.com/read/376006/2718084
out errors.out
--
-- ERRORS
--
-- bad in postquel, but ok in postsql
select 1;
?column?
----------
1
(1 row)
--
-- UNSUPPORTED STUFF
-- doesn't work
-- notify pg_class
--
--
-- SELECT
-- missing rela
www.eeworm.com/read/376006/2718085
out bit.out
--
-- BIT types
--
--
-- Build tables for testing
--
CREATE TABLE BIT_TABLE(b BIT(11));
INSERT INTO BIT_TABLE VALUES (B'10'); -- too short
ERROR: bit string length 2 does not match type bit(11)
INSER
www.eeworm.com/read/376006/2718086
out portals.out
--
-- Cursor regression tests
--
BEGIN;
DECLARE foo1 SCROLL CURSOR FOR SELECT * FROM tenk1 ORDER BY unique2;
DECLARE foo2 SCROLL CURSOR FOR SELECT * FROM tenk2;
DECLARE foo3 SCROLL CURSOR FOR SELECT *
www.eeworm.com/read/376006/2718087
out namespace.out
--
-- Regression tests for schemas (namespaces)
--
CREATE SCHEMA test_schema_1
CREATE UNIQUE INDEX abc_a_idx ON abc (a)
CREATE VIEW abc_view AS
SELECT a+1 AS a, b+1 AS b FR
www.eeworm.com/read/376006/2718089
out union.out
--
-- UNION (also INTERSECT, EXCEPT)
--
-- Simple UNION constructs
SELECT 1 AS two UNION SELECT 2;
two
-----
1
2
(2 rows)
SELECT 1 AS one UNION SELECT 1;
one
-----
1
(1 row)
SELECT 1 AS
www.eeworm.com/read/376006/2718090
out rules.out
--
-- 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 rt